Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
highlighting only the currently selected cell, until i click off o | Excel Discussion (Misc queries) | |||
Highlighting one chart item | Charts and Charting in Excel | |||
CHANGE THE COLOR OF HIGHLIGHTING SELECTED TEXT | Excel Discussion (Misc queries) | |||
Excluding VAT for selected item | Excel Worksheet Functions | |||
Selected cell highlighting has vanished...no shading now. | Excel Worksheet Functions |