• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple Dependent Checkbox to hide unhide sheet

paradise

Member
Hi,
I have a multiple sheets (currently mentioned only few).I have made one master sheet whose name is "Master".In "Master" sheet in C column I have made checkbox whose corresponding worksheet name is in D column.In E column ,I have mentioned another worksheet which is dependent on D column and checkbox mentioned in F column (But I could not be able to link it).

In nutshell,D is main group worksheet name,E is subgroup worksheet name dependent to D and the most important one is that there are other worksheets which is further subgroup of E whose name I have not mentioned here in "Master" sheet.But I have mentioned the E column worksheet name of Master sheet in F1

Now What I want is that when I check on C column and F column checkboxes that worksheets should be visible,rest should be hidden.In addition to it,E column dependent worksheet whose name is mentioned in F1 in any worksheets that should also be visible.

Hope I could able to make it understand.If any information required then kindly let me know.
 

Attachments

  • Checkbox.xlsm
    36.7 KB · Views: 2
Still not got as expected.

Kindly note following condition should be met -

1st Condition:

When Column C and Column F checkbox if any it is unchecked then it should be hidden except master sheet

But,

Sheet12,Sheet13 and Sheet14 is still not hidden (these worksheet name I have not mentioned in Master sheet as they are dependent on E worksheet name in F1)

2nd Condition:

You have not linked F column check box.i.e for e.g if F7 is checked then it should be unhidden/visible,including

i) D5 worksheet name and

ii) most important the worksheets i.e equal to all other worksheet whose name in E7 worksheet name = worksheet name displayed in F1 in all other worksheets apart from the worksheet name mentioned in Master sheet.Here in this case it is Sheet12,Sheet13 and Sheet14 (as E7 of master sheet = name displayed in F1 in all these Sheet12,Sheet13 and Sheet14
Here only a sample is mentioned,there might be more )

Hope this would be suffice info.
 
I'm not about to set up your entire workbook for you. If you can't work out the rest with sample code provided. Please upload file with all sheets and check boxes set up.
 
ok ,I have added few more sheets.Hopefully,if this would be fine for me.I don't want any check box in any other worksheets other than those mentioned in "Master" sheet.Those worksheet that don't have checkbox is linked to E column respective worksheet that is associated.

Kindly refer to my post 3 and plz note that condition mentioned thereon must be fulfilled.
I have no or little knowledge only.

Thanx & hope u will sort out the missing issues/coditions that u have left.
 

Attachments

  • Checkbox_1.xlsm
    39 KB · Views: 5
Back
Top