Highlighting ser selected item!
 

Hello all!

A quick qn: I created a menu with sub menus and stuff in a workbook.
The submenus have toolbars attached to them and will be selected by th
user.
The toolbars inturn have macros assigned to them, performing specifi
tasks.
But I would like to have the user selected item highlighted by a 'tic
mark'? This way, the user will know his selection.

Thanks, lookforward to your help guys.

Arun.
Vtec Corp

--
Message posted from http://www.ExcelForum.com

Highlighting ser selected item!
 

You van have a check mark alongside to in dicate it button state,. but it
will stay checked unless you turn it off with another click.

This is an example of a macro assigned to a commandbar taht would do this

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


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"aiyer " wrote in message
...
Hello all!

A quick qn: I created a menu with sub menus and stuff in a workbook.
The submenus have toolbars attached to them and will be selected by the
user.
The toolbars inturn have macros assigned to them, performing specific
tasks.
But I would like to have the user selected item highlighted by a 'tick
mark'? This way, the user will know his selection.

Thanks, lookforward to your help guys.

Arun.
Vtec Corp.


---
Message posted from http://www.ExcelForum.com/