#1
|
|||
|
|||
How to hide and unhide sheet according to drop down list
Hi,
I have a list in one sheet that changes from No 1 to No 50 according to drop down list. Each number is created as separate sheet. But I don't want so many sheets in my workbook when there is only a few list. Let's say when there is only 3 in list, I want to hide the rest 47 sheets in workbook. I tried macro but it doesn't reappear the sheet after changing the list. Here is my code. Please kindly suggest any improvement to hide and unhide sheets. Sub HIde() Sheets("Heading ").Select Range("B9").Select If Range("B9").Value = " " Then Sheets("Saya 1.1 (4.2))").Select Sheets("Saya 1.1 (4.2)").Visible = False Else Sheets("Saya 1.1 (4.2)").Visible = True End If End Sub Thanks in advance. |
#2
|
|||
|
|||
Original post deleted.
Wasn't marked solved when I originally posted and is now marked solved without the OP ever logging in. What's the point ? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hide / unhide Rows | NullVBA | Excel Programming | 4 | 12-09-2015 05:10 AM |
Hide/Unhide Text Based on Drop Down Selection | gw1500se | Word | 3 | 02-19-2015 12:17 PM |
How Custom Drop List in Ledger Sheet? | martyg | Excel | 0 | 02-22-2012 07:18 PM |
Hide/Unhide pictures | maloneb | PowerPoint | 1 | 01-18-2012 03:34 PM |
Unhide and Re-hide in Excel 2003 | thorgal67 | Excel | 1 | 07-16-2009 07:06 AM |