Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have on average 10 option buttons along with check boxes per each worksheet.
They are currently colored to blend with the sheet colors (2 to three different colors per sheet). I am adding a command button on the 1st sheet (FaceSheet) to strip all color from all worksheets and to also strip the color of all option buttons and check boxes. Is there a way to write some code that will select all option buttons and check boxes on all worksheets and strip them of their color? (Currently I am envisioning a super long array with all option buttons and check box names, I would like to avoid this). Also after the print action, I would like all worksheets and option buttons and check boxes to get their colors back to the same colors as before. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking option buttons and returning data across worksheets | Excel Discussion (Misc queries) | |||
Change Header & Footer Info w/ Worksheet Option Buttons | Excel Discussion (Misc queries) | |||
Change text for option buttons in message box | Excel Programming | |||
Worksheets and Control Option Buttons | Excel Worksheet Functions | |||
How to change color of buttons if pressed? | Excel Programming |