WHEN I SAVE MY PROJECT TO A NETWORK DRIVE OR OTHER LOCATION OTHER THAN THE ONE DURING DEVELOPMENT, THE MACRO ADOPTS THE NEW PATH SO MY MENUS CANT FIND THE MACRO ASSIGNED. ANY IDEAS?
THANKS FOR YOUR HELP
WHEN I SAVE MY PROJECT TO A NETWORK DRIVE OR OTHER LOCATION OTHER THAN THE ONE DURING DEVELOPMENT, THE MACRO ADOPTS THE NEW PATH SO MY MENUS CANT FIND THE MACRO ASSIGNED. ANY IDEAS?
THANKS FOR YOUR HELP
Can i ask what windows version your using on the desktop and network server
Also version of Excel, sounds very ??? Ive been here before
Jack in the UK
Hi Mike
It sounds like you need to Attach the Custom Toolbar to the Workbook.
To attach a Custom Toolbar go to View>Toolbars>Customize-Attach then Copy your Custom Toolbar to the Workbook.
See HERE for more details.
Once this is done, you will Need to Delete it (not as drastic as it sounds) from the Workbook before making any modifications, then Attach it and save. If you don't, your changes will not stick.
Don’t have an account yet? Register yourself now and be a part of our community!