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,each time i open a new file, i cant see my macro in the dropdown as you how you mentioned.. i have to unhide it..so to see my macro, i have to open my 'personal.xlsb' which i have created a shortcut on desktop.. then go to the new workbook which i want to work on -> go to 'View' -> click 'Unhide' -> then only my macro will show under the dropdown.. i have to these steps each time i want to use the macro..
Hi Helmi,
apart from what Wyn has mentioned, could you please double check if Personal.xlsb has been disabled by Excel. You can do it by going to Excel Options -> Add-ins->Select 'Disabled Items' in the 'Manage:' menu -> Go. If you can see Personal in the list, please enable it, then close the workbook, reopen again and check if you can now see your macros.
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..haha..
- Hi Helmi,
Can you let us know what the macro does.
One option is to assign the macro to a Quick Access Toolbar button (or a keyboard shortcut). Then you can run it without opening the Personal Workbook.
Sorry to jump in on this Yury - I'm sure you'll forgive me ;)- Hi Wyn,
The macro is for me to save a set of steps which can be used with just a click of a button i assign for my future use.. so i dont have to keep going through the long steps each time i open a new workbook.. its a repitition of steps with a click of a button.. it saves me a lot of time..
