I have a sheet which uses two custom menus that contain numerous macro buttons. In order for these macros to stay associated with the sheet after doing a 'Save As', it is necessary to delete these toolbars on deactivating the sheet, and not merely disable them. The menus are attached to the sheet so are loaded each time it is opened.
My problem is this:
If I switch between workbooks, my menus are deleted as I do not want them available in other environments, but when I switch back to my original sheet without closing and reopening, my toolbars are not reloaded.
I'm currently using the enable string to try to reactivate them but that isn't working. Is it possible to reload a deleted toolbar from within the active sheet without closing, or am I going to have to rethink my strategy?
If I delete the toolbars using the beforeclose field, if I hit close and then cancel out to return to my sheet, the toolbars are already deleted and render the sheet unusable.
The toolbar has been built using the custom toolbar builder, not coding, otherwise I would be able to rebuild the custom menu each time the sheet was activated.
Any way of doing this without having to churn out masses of code to build my menus?
This message was edited by Mr Nick on 2002-04-11 02:58
My problem is this:
If I switch between workbooks, my menus are deleted as I do not want them available in other environments, but when I switch back to my original sheet without closing and reopening, my toolbars are not reloaded.
I'm currently using the enable string to try to reactivate them but that isn't working. Is it possible to reload a deleted toolbar from within the active sheet without closing, or am I going to have to rethink my strategy?
If I delete the toolbars using the beforeclose field, if I hit close and then cancel out to return to my sheet, the toolbars are already deleted and render the sheet unusable.
The toolbar has been built using the custom toolbar builder, not coding, otherwise I would be able to rebuild the custom menu each time the sheet was activated.
Any way of doing this without having to churn out masses of code to build my menus?
This message was edited by Mr Nick on 2002-04-11 02:58