Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight a selection from a menu, urgent!
Hello!
I would like to highlight (possibly with a coloured 'tick mark') selected toolbar rom a menu. I.e. any toolbar selected by the user from a menu should be highlighte so that the user can see which ones were selected in the end. I wrot the following macro for the same but can't figure out what'z wrong. ============================================== Sub Macro1() 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 End Sub ============================================== I would appreciate your help guys. Thanks a bunch, best regds. Arun -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
Cell Selection Highlight | Excel Discussion (Misc queries) | |||
Lost the 'Help' menu, urgent! | Excel Programming | |||
Urgent, help needed on range selection! | Excel Programming | |||
Highlight the selection! | Excel Programming |