ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Personal.xls macros only work in that sheet (https://www.excelbanter.com/excel-programming/418035-personal-xls-macros-only-work-sheet.html)

Kevin

Personal.xls macros only work in that sheet
 
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

--
Kevin


All times are GMT +1. The time now is 01:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com