The personal workbook must be in the XLStart folder
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Chimelle" wrote in message ...
We must be thinking along the same lines -- I tried that and still nothing.
I have since searched another resource and found that unless the document
that has the macros is saved to the "My Documents" folder, it will not work.
I moved the location and now things seem to be working.
Thanks for your help!
"Ron de Bruin" wrote:
Try to create a new Personal file
Rename or delete your old one and let Excel create the file for you
See
http://www.rondebruin.nl/personal.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Chimelle" wrote in message ...
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!