Forum Discussion
Can you create a checkbox that will hide or show a tab in a worksheet?
If I create a yes/no button could it trigger the hiding or exposing of an additional tab in the same worksheet?
Riny_van_Eekelen Thanks for the reply....I would call myself an intermediate user but the coding seems to be an issue.
I am unsure of the HideSheet = Range("A1") component....
Thats the line that seems to be erroring.
I appreciate your guidance
Doc441 Can't really tell. It works fine in my file. What error message do you get?
- I guess I just need the excel for dummies step by step version....
I don't understand the HideSheet = Range("A1") line. In particular cell A1 on what page?.The variable "HideSheet" is declared as a "Boolean". That means, it can hold TRUE or FALSE.
A1 is the cell that is linked to the CheckBox. Check the box and A1 becomes TRUE. Uncheck the box and A1 becomes FALSE.
The code "If HideSheet Then" looks if the box was checked. If so, Hide the sheet ELSE unhide it.