Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Min Min is offline
external usenet poster
 
Posts: 40
Default Check boxes

I have a workbook with 14 worksheets. Each worksheet has 6 checkboxes that
when true will show columns and when false will hide them again. The
checkboxes perform the same function on each worksheet. At the moment I have
the code on each sheet - exactly the same code 14 times over!
Is there any way of putting the code into just one place?
I tried doing it with macros but, although the columns would hide, they
wouldn't show again when the box was deselected.
Any help would be greatly appreciated, but my knowledge is very limited so
explanations need to be one step at a time!
Many thanks.
 
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
Check boxes Irishsuly Excel Discussion (Misc queries) 2 November 29th 06 12:20 AM
Check Boxes MACAVITY500 Excel Discussion (Misc queries) 4 November 18th 06 11:45 PM
How do I increase the size of check in check boxes Adams, Les Excel Discussion (Misc queries) 0 September 19th 06 02:35 PM
Enable check box in protected sheet + group check boxes Dexxterr Excel Discussion (Misc queries) 4 August 2nd 06 12:00 PM
How do i create a value for check boxes or option boxes Tim wr Excel Discussion (Misc queries) 1 February 9th 06 10:29 PM


All times are GMT +1. The time now is 01:59 PM.

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"