Disable / Enable Macro's
Posted by Rod Quinlan on November 21, 2001 8:19 AM
I have a spreadsheet that has command buttons which act as hyperlinks allowing me to move to various areas in my spreadsheet. This is done by clicking on the action buttons.
My question is every morning when I open the spreadsheet for the first time Excel displays a message "disable macros or enable macros. When I choose enable macros it turns off the ability to use my action buttons/hyperlinks. How can I correct this this that I can enalbe macros and use my hyperlinks.