Error due Changed Drive

D

Don

Excel 2003

I created a project with a custom toolbar, which calls various assigned
macros.
Originally, this was all done in the drive designated "D".
A recent total O/S reinstall has re-assigned this drive to "E".
When I now try to use the items on the custom toolbar
I get an error message saying The macro D:\...........cannot be found.
I can click customise and reassign the toolbar buttons,
and this works for the current session but it cannot be saved
and the next time the project is opened I get the same error message.
Is there a simple solution?
donwb
 
P

Peter T

It sounds like the custom toolbar is being recreated in each session (as an
addin loads), or the toolbar is attached to a file. If the former I assume
it would be obvious to merely change the toolbar code. If the latter resave
the file or addin that the toolbar is attached to with the amended OnAction
strings in the toolbar.

Regards,
Peter T
 

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

Moved file, changed path, macros don't work 3
Deleted Custom Toolbar keeps returning. 3
Error message Macro cannot be found 2
changing drive letter in custom macro toolbar buttons 3
Links broken when spreadsheet emailed 6
Macro files will not open 1
How does XL "lose" a macro that's right there? 5
Toolbars in Excel 2007 6

Top