PDA

View Full Version : Disabling Toolbars in 2003



r66eay
03-02-2010, 07:29 AM
I have some code that successfully disables all toolbars when the user opens the workbook and then re-enables when it is closed. If this workbook is opened whilst another workbook (without the code) is already open and I switch between workbooks then the toolbars now are enabled when I need them to be disabled.

Is it possible for the toolbars to remain disabled in the workbook where my code is even if I switch back and forth from a workbook that doesn't require toolbars to be disabled?

xld
03-02-2010, 07:52 AM
ADd the same code to the workbook_activate event.

r66eay
03-02-2010, 07:56 AM
Thanks, that worked perfectly.