98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · Low Priority · Version Standard
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Display pictures on Chart Data PointReplacing a single chart data point bar with a picture. |