Hi Guys,
I have a Add in that creates a custom menubar .. I need to disable only a certian control in my custom menubar.
I used the following line
Code
' The Tag refers to a Commandbar control that opens a new report.
Application.CommandBars.FindControl(Tag:="GRNew Report").Enabled = False
This however is not disabling my New report commandbar button ...
I have also tried the following approach ..
Code
Dim temp as variant
Set temp = CommandBars.FindControl(Type:=msoControlPopup, Tag:="GRNew Report")
temp.enabled = false
The findcontrol method works fine & returns proper control .. but the Enabled property is not working !!! Please help , this is driving me crazy !!