Excel VBA - Using checkboxes to hide/unhide worksheets

[Shelby21]

Hi guys,

I need some help with a spreadhseet I have been working on for months.
I'm not very good with VBA and don't think there is any other way to accomplish what I am trying to do below.

Any help would be much appreciated!

This spreadsheet has the following tabs:

DC_Info
Instructions
LP
IR_Setup
PASS
CR_Setup
IR_Teaching
CR_Teaching
Robot_Teaching_Verifications
Wafer_Slip_DCP's
KMTerm_Commands
SU3200_Shims
Revision_History

What I am trying to do:

The table below is located in the Instructions tab.

I would like to link each checkbox to its corresponding worksheet

Checking the box makes the worksheet visible

Unchecking the box hides the worksheet

I would also like to be able to center the checkboxes within column E and have solid border for the checkbox instead of just the two line bordered checkboxes shown below

If possible, a last item would be to highlight cell of the worksheet name yellow if the checkbox is checked.

 

[Shelby21]

Hi Saura,

Thank you for your response on how to resolve the issue during worksheet protection.
I tried your method, but this isn't going to work for what I need.
Using that method unlocks the worksheet that is selected allowing the end user to view and modify formulas and cells, which I do not want.

The work around I came up with is to run a worksheet macro I put in that will protect all worksheets by pressing Ctrl + Shift + P
Once all worksheets are protected, I unprotect the Instructions tab that contains the checkboxes for all the other tabs.
Press protect worksheet and check the box for format cells, which is only applied to the Instructions tab.

Viola!

Everything is protected the way I want and the tab checkboxes are working as intended.