How to add a disclaimer sheet to open very hidden sheets

[jeffpanagos]

I want to have users accept a disclaimer before accessing the rest of a workbook. I know that I have to make the other sheets "very hidden" but I am not sure how to make them open by clicking a check box. Can anyone help with this.

Thank you very much

[teylyn]

You could have followed up on this in your original question. Consider a button instead of a check box. Or use a check box, and then let them hit a button to "OK" the selection.

Please Login or Register  to view this content.

[jeffpanagos]

You could have followed up on this in your original question. Consider a button instead of a check box. Or use a check box, and then let them hit a button to "OK" the selection.

Please Login or Register  to view this content.

Thank you for your help. I will give this a try. Vba is a whole new thing for me. Thanks again

[jeffpanagos]

Thank you for the code. however i am a little lost. I "very hidden" the sheets with the exception of the disclaimer. I made a button and entered the code in VBA and hit run but nothing became visible. I think my order of operation is incorrect. Again sorry this is a whole new world for me in excel. any chance you would know where I could find step by step tutorial on this?

Thanks

[6StringJazzer]

You may not have your button linked to the code correctly. Can you attach your file? The code above is simple and definitely works, so my only guess is that whatever you are doing is not actually running the code.

[jeffpanagos]

I have uploaded an example. Let me explain what I am trying to accomplish and maybe there is a better way to go about it. when my customers have a question what is in one of our menu items. I want to give
them a tablet with with an excel workbook with all ingredients in a menu item but I want them to accept a disclaimer before they have access to the information. i would also like to have the disclaimer come up first every time the
workbook is opened.

Thank you very much for taking the time with this.

[6StringJazzer]

You did not have any code to handle the button click. I added it for you.

[jeffpanagos]

Thank you for help. I got it to work on my desk top. Unfortunatly it does not work on a tablet. If you have any suggestion on how to do this. I am open.

Thanks,

Jeff

[6StringJazzer]

What type of tablet, and what app? I do not know if macros run on the tablet versions of Excel.

[teylyn]

>> I do not know if macros run on the tablet versions of Excel.

They don't. VBA is only supported on desktop Excel.