How to automaticaly hide all toolbars in in workbook when another workbooks are open?

[Igor Sudnik]

Hi. I'm a newbee. I've created a macro which automatically starts windows
timer on Workbook_Open. But users still have an option to start timer from
tools menu and when they do that Excel just stops responding. And there are
a few reasons to hide all the toolbars in this particular workbook. But at
the same time if user has any other workbooks open he'd have all tools and
menus available for those workbooks. Is there any way to do that with VBA?
Any help on this is much appreciated.

 

[Bob Phillips]

On the chosen workbook, hide the toolbars on the workbook open and activate
events. Restore them on deactivate.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)