Hide and Unhide sheet based on Checkbox status

Try the following:

Create an Active X check box and apply the following code to it:

Please Login or Register  to view this content.

Change the red text in the above code to match the name of the check box you inserted.

Then add the following to a new module:

Please Login or Register  to view this content.

The first line of the HideMOTP code is not really necessary, but I like to throw it in there to make sure that sheet is always visible before the rest of the macro tries to run. Otherwise, if you have manually hidden the tab and try to run the macro, you will get an error.

You can obviously change the range you are selecting in the HideMOTP macro in order to clear more than just the three specific cells you mentioned for your example.

Hello MagicMan,

The CheckBox in your Workbook is a Forms Control CheckBox and not an Active X CheckBox. The CheckBox showes as CheckBox 4.

In a Standard Module enter the Code Below and, assign a Macro to run from that same Module.

Please Login or Register  to view this content.

Try the attached sample.

Regards.

Hello MagicMan,

Murphy is playing silly bugger with me!

Here is the correct Code:

Please Login or Register  to view this content.

Regards

Thank you for the feedback and Rep+, MagicMan,

You are welcome. Glad I could help!

Regards.