Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default Hiding checkboxes

I have a spread sheet that has several check boxes. When a certain check box
is checked I need to hide other check boxes along with hiding the row. I
know how to hide the row when a check box is ticked but I need help hiding
the check boxes. Is this possible? Any help would be appreciated.
  #2   Report Post  
Posted to microsoft.public.excel.programming
JNW JNW is offline
external usenet poster
 
Posts: 480
Default Hiding checkboxes

set the visible property to false. i.e. checkbox1.visible = false.
You'd do this in the same event that you would use to hide rows.
--
JNW


"Tammy H" wrote:

I have a spread sheet that has several check boxes. When a certain check box
is checked I need to hide other check boxes along with hiding the row. I
know how to hide the row when a check box is ticked but I need help hiding
the check boxes. Is this possible? Any help would be appreciated.

Reply
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
need code for hiding/unhiding sheets using checkboxes pzx8hf Excel Worksheet Functions 1 August 13th 08 12:11 AM
Hiding Control Toolbar Checkboxes Ellen G Excel Discussion (Misc queries) 2 September 24th 07 09:59 PM
Hiding Rows with Checkboxes Ellen G Excel Discussion (Misc queries) 1 April 6th 07 08:00 PM
checkboxes hiding or introducing new worksheets el_peacock[_2_] Excel Programming 2 October 23rd 04 06:15 PM
hiding showing columns using checkboxes ronda Excel Programming 1 June 8th 04 01:27 AM


All times are GMT +1. The time now is 03:31 PM.

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

About Us

"It's about Microsoft Excel"