how to disable submenu of custom menu in Excel 2000 using VBA?

0 ⤊

how to disable submenu of custom menu in Excel 2000 using VBA?

I would like to disable submenu of menubar in excel 2000 using vba.
But below mentioned code is not working.......
CommandBars("Worksheet Menu Bar").Controls("Menu").Controls("SubMenu").Enabled = False

kindly guide me.

2006-07-16 20:04:02 · 1 answers · asked by padam_india 1 in Computers & Internet ➔ Programming & Design

1 answers

try CommandBars("Worksheet Menu Bar").Controls("Menu").enable = false

2006-07-19 09:31:48 · answer #1 · answered by adi 2 · 0⤊ 0⤋