Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlighting a selection!
Hi all!
Thanks alot Bob and I tried the following as suggsted, to have a chec mark alongside to indicate it button state. I,.e, I developed a Vtec menu with sub menus within it and the submenu were linked to toolbars to which macros are assigned to. I have assigned macros to toolbars. In one of those macros, I added th following assuming that the selected toolbar will be highlighted. Fo eg, one of the toolbars named as 'static' connected to sub-men 'Analysis type' from the 'Vtec ' main menu will have to be highlighte when the user clicks the same. ========================================== 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 =========================================== But am getting an error message that says 'subscript error' and in th debugging mode, I could see that the error was happening at th following line: "ActiveWorkbook.Worksheets(.Caption).Visible = xlSheetHidden .State = msoButtonDown" I would appreciate your help guys. Thanks a lot, Arun. Vtec corp -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: Selection windows slows down when highlighting cells | Excel Discussion (Misc queries) | |||
Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Row selection/highlighting | Excel Discussion (Misc queries) | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) |