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: 6
Default Checkbox Control to Hide/Unhide Worksheet

I am tyring to create control sheet using forms control that would hide or
unhide depending if the box is checked or not.
Ideally, when the box is checked it would pass the worksheet name to my vba
code to hide/unhide the named worksheet.

Where I'm running into trouble is creating a macro that can be assigned to
the checkbox.

Not sure if I am using the best approach to doing this and would appreciate
any suggestions.

Thanks,
Peter





 
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
hide, unhide column or row after protect worksheet tiny[_2_] Excel Discussion (Misc queries) 2 May 14th 09 04:23 PM
how do I protect a worksheet and still use a checkbox control JayS Excel Worksheet Functions 4 September 8th 05 07:36 AM
Can I hide a worksheet and set a passwd to unhide it? puneetarora_12 Excel Discussion (Misc queries) 2 July 24th 05 06:06 PM
Can I hide a worksheet and set a passwd to unhide it? puneetarora_12 Excel Worksheet Functions 1 July 24th 05 08:50 AM
Checkbox to hide and unhide rows Please. Steved Excel Worksheet Functions 2 December 6th 04 11:30 PM


All times are GMT +1. The time now is 08:27 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"