Personal.xls macros only work in that sheet

K

Kevin

Hi

I upgraded from Office 97 to Office 2007. I copied over my previous
personal.xls file to the XLSTART drive, replacing existing one.

The macros only work on my Personal.xls workbook and not any other ie i get
a message - "Cannot run macro. The macro may not be avaialbe in
this workbook or all macros may be disabled". The macros are not disabled

There must be some setting I can change so they can be used by all workbooks

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Personal.xls macros will not work in any other sheet 1
Need Help with Macro Security 1
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Menu Macro Not Executing - Need Help 1
Macros always available in Personal.xls? 8
Macros in PERSONAL.XLS 1
Digitally Signed Macros in Personal.XLS 3
macros only work in Personals.xls workbook 0

Top