View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matz Matz is offline
external usenet poster
 
Posts: 5
Default How to identify active Menu Bars

Hi,

I need a sub procedure that identifies all active Menu Bars when opening a
workbook.

- Then store the ID
- disable all found Menus
- active a customized Menu (That works already)

before closing Workbook:
- disable customized Menu (That works already)
- enable alle menus that was active in the beginning

I tried something with .findcontrols but I coudn't get it running.

Thanks!!