Accessing personal macro's all the time
Thank you
--
Al
"Norman Jones" wrote:
Hi Al,
"AMK" wrote in message
...
Hi
How does one set up a "Personal Macro Workbook"? I cannot find the store
dropdown menu.
Thanks.--
Al
Tools | Macro | Record New Macro
Enter "MyDummyMacro" in the Name
Leave the Shortcut box blank
In the next box (which is a dropdown), select:
'Personal Macro Workbook'
Click OK
Click the 'Stop Recording' toolbar button.
You will now have a hidden Personal workbook which will reside in your
XlStart folder and will open (hidden) everytime that you manually open XL.
(In my version of XL, the dropdown box has a 'Store Macro In' caption - but
this may be different for you!)
---
Regards,
Norman
|