View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Igor Sudnik Igor Sudnik is offline
external usenet poster
 
Posts: 9
Default How to automaticaly hide all toolbars in in workbook when another workbooks are open?

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.