-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
sheetssheet2.visible
-
T
VBA code to hide and unhide sheets in a workbook with over 20 sheets
Hi, I have a sheet that has a bunch of sheets, created a menu sheet with a drop down to unhide all but the specific sheet, but its not working correctly, this is the code on a test one that I created as a practice workbook - I'm not sure where I'm going wrong. It works if I only have one...- tbrynard01
- Thread
- false sheet sheetssheet2.visible sheetssheet3.visible true
- Replies: 8
- Forum: Excel Questions
-
R
Hide/Unhide Sheets Value on other cell through formula
Hello, I'm stuck so hopefully somebody can help me with this. I'm trying to Hide or Unhide some sheets depending on the value of another cell. I have this: Private Sub Worksheet_Change(ByVal Target As Range) If [E3] = "YES" Then Sheets("Sheet2").Visible = True Else Sheets("Sheet2").Visible =...- Rioux
- Thread
- cell depending sheets sheetssheet2.visible work
- Replies: 4
- Forum: Excel Questions
