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