LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default Change color of all option buttons in several worksheets

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking option buttons and returning data across worksheets Cheryl C Excel Discussion (Misc queries) 0 March 1st 10 05:01 PM
Change Header & Footer Info w/ Worksheet Option Buttons Ryan H Excel Discussion (Misc queries) 0 December 8th 09 03:09 PM
Change text for option buttons in message box JDaywalt Excel Programming 1 March 31st 08 05:28 PM
Worksheets and Control Option Buttons KHaydel Excel Worksheet Functions 1 April 9th 07 11:19 PM
How to change color of buttons if pressed? Phillips Excel Programming 1 December 11th 03 01:05 AM


All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"