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

presentation available macros

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Presentation of available macros

Presentation of available macros

ResolvedVersion 2007

Simon has attended:
Excel VBA Intro Intermediate course

Presentation of available macros

Why is it sometimes the macos appear with the full file name before the macro name and others don't?

RE: Presentation of available macros

Hello Simon,

Hope you enjoyed your Microsoft VBA course with BEST Training.
Thank you for your question regarding Macros

If a macro is recorded to the Personnal Macro Workbook and you are currently viewing another workbook, then the macro name will follow the path to the personnal macro workbook.

If you were viewing the Personnal macro workbook, then the macros you recorded in the other workbook e.g. Book1 would show the full path before the macro name.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Thu 18 Nov 2010: Automatically marked as resolved.

 

Training courses

Training information:

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.