presentation available macros

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

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

Presentation of available macros

resolvedResolved · Low Priority · Version 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:

Create Charts with One keystroke

Create a graph with one click

1. Select your data.
2. Press F11.
3. You have a graph.

View all Excel hints and tips


Server loaded in 0.07 secs.