I have tried changing to allow all macros to run but it did not change
anything.
"Ron de Bruin" wrote:
Hi Chimelle
Change your security
Office ButtonExcel Options
Trust CenterTrust Center SettingsMacro Settings
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Chimelle" wrote in message ...
Greetings all!
I'm struggling with macros in Excel 2007. I've saved a macro and assigned
it to the Personal workbook -- thinking that these macros would be available
whenever I open a new spreadsheet. I've tried to hide the Personal
spreadsheet and also have unhidden it. Neither seems to allow me to use the
macros that I have just saved.
The error message I get is this: Cannot run the macro -- macro name -- The
macro may not be available in this workbook or all macros may be disabled.
Any help would be greatly appreciated!