Menu problem in Excel
Hello group,
I'm trying to hide a user-defined menu item in Menu bar during
following event:
Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
Application.Commandbar("My Menu").Visible =
False
End Sub
Which causes run time error '91' or "Object variable or With block
variable not set"
Does anybody know how can fix this?
Your help will be appreciated.
Thanks,
akohan
|