Personal.xls macros will not work in any other sheet

  • Thread starter Thread starter Kevin
  • Start date Start date
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
 
figured it out - old file i copied over was .xls - it needed to be in the
new format .xlsb
 
Back
Top