Disabling Toolbars in 2003

[r66eay]

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?

[Bob Phillips]

ADd the same code to the workbook_activate event.

[r66eay]

Thanks, that worked perfectly.