ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help Ofc Excel2003 macro locations (https://www.excelbanter.com/excel-programming/298484-help-re-ofc-excel2003-macro-locations.html)

Perico

Help Ofc Excel2003 macro locations
 
When I unhide my Personal.xls its properties show at location C:\Program Files\Microsoft Office\OFFICE11\xlstart

However, when I click my buttons to which I've assigned macros, I keep getting the message, "The macro "C:\Program Files\Microsoft Office\OFFICE\xlstart\Personal.xls'!mymacro' cannot be found

I've gone in and corrected that portion of the path from ...\OFFICE\... to ...\OFFICE11... by right clicking the macro button and clicking the Assign Macro button and editing the top text box with the path, but it seems to do no good - it doesn't stick as I get the same message the next time I start Excel and try to use one of my macros

How can I get Excel 2003 to find my macros? I ran a Repair it did not correct the problem.


All times are GMT +1. The time now is 11:10 PM.

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