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 » Macros
Macros
Resolved · Low Priority · Version 2003
Guangwen has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Macros
Where is the personal macro file stored?
RE: Macros
Hello Guy, Thank you for your post, the Personal Macro file is a worksheet which sits hidden behind the active worksheet, when you record a macro and place it on the Personal Macro worksheet it is available to all active worksheets in that Workbook. To delete a macro from the Personal Macro worksheet you must first hide the active worksheet, Window, Hide, then choose to Unhide, at which point you will be asked which worksheet to open, the active worksheet or the Macro worksheet, if you choose the Macro worksheet you can then access your macros in the normal way to edit or delete them. I hope that helps, best regards Pete
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:Paste a web address into the hyperlink address fieldIf you copy a web address the only way to paste into the address field of the hyperlink box is to use CTRL + V. Right click paste does not work. |