Forum Discussion
Unhide macros
I have created and save a macro under the 'personal' workbook.. to my understanding, each time i open an excel file, i could execute the macro instantly.. BUT instead, i have to keep unhiding the macr...
Hi Helmi,
could you please clarify what you do to unhide the macro? If you open a file, then go to Developer->Code->Macros, select either 'All Open Wookbooks' or 'PERSONAL.XLSB' in the "Macro in:" dropdown, can you see your macro listed in the 'Macro' window?
Thanks
Yury
Hi Yury ,
Yes i did go to the 'disabled items' but nothing listed there.. this is the problem im facing.. i mean im able to use the macro, just few steps i have to do which i mentioned earlier.. quite tedious..
Yes i did go to the 'disabled items' but nothing listed there.. this is the problem im facing.. i mean im able to use the macro, just few steps i have to do which i mentioned earlier.. quite tedious..
Hi Helmi
Do you have the Developer Ribbon showing in Excel?
Also try this:
Right Click on the Excel Ribbon (menu)
> Customise Quick Access Toolbar
> Popular Commands drop down
> Macros
Can you see PERSONAL.XLSB "your macro name"- No unfortunately im unable to..
Those macros should be visible. Do you happen to have Option Private Module at the top of the module with your macro, or dos the macro start with the word "Private".
