excel 2003 visual basic intermediate course - macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Macros

excel 2003 visual basic intermediate course - Macros

resolvedResolved · Low Priority · Version Standard

Ahmed has attended:
Excel Advanced course

Macros

How do you assign a macro?

RE: Macros

Hi Ahmed,

Thank you for your question.

To assign a macro, you need to select an item (draw an autoshape, insert a new button on your toolbar, a picture...etc) to assign first. Right click on the item and select assign macro will setup the link.

For assigning a macro button on your toolbar:
1) TOOLS menu > CUSTOMIZE
2) COMMANDS tab > category MACROS > (right window) drag up the icon: CUSTOM BUTTON onto the toolbar
3) right click the newly inserted BUTTON:
> ASSIGN MACRO > choose the preferred macro
*You can also change the button name / image
4) press OK on CUSTOMIZE window

Hope this helps.

Katie

RE: Macros

Thank you for your reply.

However, I want to make this comment;

I was impressed by the course I attended on the 30/11/07.

The trainer - Sandy Grey was excellent.

In my opinion, it is difficult for a student to make notes, follow a Tutor's instructions, and perform the instructions on his/her PC at the same time.

Even though Ms Grey was patient to ensure every student understood and completed a specific topic, there were occasions other topics were rushed because we were running out of tme.

In circumstances like this, I have always relied on my student notes.

At home on Saturday - 01/12/07, I printed the MS EXCEL 2003 ADVANCED COURSE Notes from the CD given.


Unfortunately, there are no notes on :

- Advanced Formulas
- Macros.

Pivot tables is well explained in the notes..

Infact, I attended the course because of the 3 topics above
and even though they were covered on the day, I still need the notes to refresh my mind from time to time.

Could you please send me notes on the 2 topics above to enable me apply these applications.

The interactive questions are not good for me.

Thank you.


Ahmed.




RE: Macros

Hi Ahmed,

I have sent you an email for the Excel notes on Macros. Do let me know if you have further queries.

Katie


 

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips


Server loaded in 0.08 secs.