Thanks so much for your great help. It is working great and I have submitted it to my boss :)
THANKS SO MUCH!
tezarin
Last Activity: Jul 12 '07, 05:12 PM
Joined: Apr 5 '07
Location:
-
-
Hey Sammy,
Thank you very much for your very helpful reply. It worked great. I appreciate your help so much :)
Have a great weekend,
TezarinLeave a comment:
-
Hi Sammy,
Thanks for your reply. I tried it, but it didn't worked.
I am doing something wrong... Probably the name of the checkbox is not CheckBox1....
The code works if I create a UserForm in Visual Basic View, but I would like the checkbox to be on Sheet2.
1) In Excel 2003, I put a checkbox from the Form toolbar (in sheet view not in visual basic view) on the sheet 2, the name shown there is Check...Leave a comment:
-
Check / Un-Check to display or hide a sheet
Hi all,
I have an Excel sheet whith 2 sheets called Sheet1 and Sheet 2.
I added a checkbox to the sheet 2 and would like it to work like this:
1) When the checkbox is checked the Sheet1 becomes hidden
2) When the checkbox is un-checked the Sheet1 becomes visible
I wrote the code below but I keep getting the "run-time error 424 Object required" error. Please help me with that if possible....
No activity results to display
Leave a comment: