View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
DonB DonB is offline
external usenet poster
 
Posts: 5
Default Checkmark on Menu Item

Thanks, Bob. I'll give it a try.
DonB

"Bob Phillips" wrote:

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



--

HTH

RP
(remove nothere from the email address if mailing direct)


"DonB" wrote in message
...
I want to be able to put a checkmark beside a menu item when the user

selects
that item from the menu. For example, under the View menu when the user
selects Task Pane the pane appears and a checkmark appears beside the

'Task
Pane' on the menu.

I would expect something like CommandBarControl.checked but it's not that
straightforward.

I used to know how to do this but the method has slipped my mind. Please

help.

Thank you.