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!!
|