View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default John Walkenbach's Custom Menus

The property in question is the state property.

This is an example of a macro assigned to a commandbar that would do this
With Application.CommandBars.Action*Control
If .State = msoButtonUp Then
ActiveWorkbook.Worksheets(.Cap*tion).Visible = xlSheetHidden
.State = msoButtonDown
Else
ActiveWorkbook.Worksheets(.Cap*tion).Visible = xlSheetVisible
.State = msoButtonUp
End If
End With

You would need to add another column to the menu table with the initial
state, and then you have to toggle it within other code using code like that
shown above.

--
HTH


Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Steve" wrote in message
...
I have built a custom menu using John Walkenbach's MenuMaker routine

located
at:
http://j-walk.com/ss/excel/tips/tip53.htm

What I would like is the capability to add a check mark (toggle on/off)

like
is the case on the standard Excel menu for "View / Toolbars / Standard".

Is
this a FaceID parameter? Any advice would be greatly appreciated.