A
aiyer
Hello!
I would like to highlight (possibly with a coloured 'tick mark')
selected toolbar rom a menu.
I.e. any toolbar selected by the user from a menu should be highlighte
so that the user can see which ones were selected in the end. I wrot
the following macro for the same but can't figure out what'z wrong.
==============================================
Sub Macro1()
With Application.CommandBars.ActionControl
If .State = msoButtonUp Then
ActiveWorkbook.Worksheets(.Caption).Visible = xlSheetHidden
.State = msoButtonDown
Else
ActiveWorkbook.Worksheets(.Caption).Visible = xlSheetVisible
.State = msoButtonUp
End If
End With
End Sub
==============================================
I would appreciate your help guys.
Thanks a bunch, best regds.
Arun
I would like to highlight (possibly with a coloured 'tick mark')
selected toolbar rom a menu.
I.e. any toolbar selected by the user from a menu should be highlighte
so that the user can see which ones were selected in the end. I wrot
the following macro for the same but can't figure out what'z wrong.
==============================================
Sub Macro1()
With Application.CommandBars.ActionControl
If .State = msoButtonUp Then
ActiveWorkbook.Worksheets(.Caption).Visible = xlSheetHidden
.State = msoButtonDown
Else
ActiveWorkbook.Worksheets(.Caption).Visible = xlSheetVisible
.State = msoButtonUp
End If
End With
End Sub
==============================================
I would appreciate your help guys.
Thanks a bunch, best regds.
Arun