Checkmark on Menu Item

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>