You can enable / disable items in the Menu Bar back in VBA. The following is the Control Number to enable / Disable
CommandBar Control ID
--------------------------------------------------------------------
Worksheet Menu Bar &File 30002
Worksheet Menu Bar &Edit 30003
Worksheet Menu Bar &View 30004
Worksheet Menu Bar &Insert 30005
Worksheet Menu Bar F&ormat 30006
Worksheet Menu Bar &Tools 30007
Worksheet Menu Bar &Data 30011
Worksheet Menu Bar &Window 30009
Worksheet Menu Bar &Help 30010
Chart Menu Bar &File 30002
Chart Menu Bar &Edit 30003
Chart Menu Bar &View 30004
Chart Menu Bar &Insert 30005
Chart Menu Bar F&ormat 30006
Chart Menu Bar &Tools 30007
Chart Menu Bar &Chart 30022
Chart Menu Bar &Window 30009
Chart Menu Bar &Help 30010
No comments:
Post a Comment