Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Presentation of available macros
|
|
|
The UK's most regular 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Presentation of available macros
Resolved · Low Priority · Version 2007
Reply Tue 9 Nov 2010, 15:50Delegate Simon said...
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?
For upcoming training course dates see: Pricing & availability
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.
|