PercyN
Programmer
- May 16, 2007
- 86
Hi, I found an article on how to disable menu items whic has been helpful but what I want to do is disable or enable particular commands specfic drop down menus on my custom menu and not the the entire menu.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
[blue] Dim CBar As Object
Set CBar = CommandBars("[purple][B][I]COmmandbarName[/I][/B][/purple]")
CBar.Controls("[purple][B][I]MenuName1[/I][/B][/purple]").Enabled = False
CBar.Controls("[purple][B][I]MenuName2[/I][/B][/purple]").Enabled = False
[green]'
'[/green]
CBar.Controls("[purple][B][I]MenuNameX[/I][/B][/purple]").Enabled = False
Set CBar = Nothing[/blue]