Disable an option on a Customised Menubar

[roddy17]

hi there,
i have a custom menubar with multiple commands. There is one though that i only want enabled (or visible if possible) when the user is viewing a report on the screen.
i thought of creating a separate menubar for this button (Close Report) but that would look less than professional.
Is there a way to disable a Menubar button? or even to make it not visible until the user is previewing a report?

thanks,
roddy

 

[Sudashan]

Hi roddy,

I hope the following code will help u
Dim CBarMenu
Dim CBarCtl

'Menu
Set CBarMenu = CommandBars("MainMenu&quot

'File Menu
Set CBarCtl = CBarMenu.Controls("File&quot

CBarMenu.Controls("File&quot.Visible = True
CBarCtl.CommandBar.Controls("New&quot.Visible = True

Sudashan