Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error due Changed Drive
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error due Changed Drive
You need to unattach the toolbar rename it (don't forget to rename it in the code) attach it and all will be well! -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35432 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error due Changed Drive
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 "Don" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links to mapped drive change to refer to local hard drive | Links and Linking in Excel | |||
Import from MS Access - Lose the drive letter..link only to drive | Excel Programming | |||
Error Trapping saving file to network drive | Excel Programming | |||
Connection error to network drive | Excel Discussion (Misc queries) | |||
Pasting a range of information from a foler on F Drive to another folder on same drive | Excel Programming |