Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-15-2017, 09:56 PM
aster aster is offline How to hide and unhide sheet according to drop down list Mac OS X How to hide and unhide sheet according to drop down list Office 2007
Novice
How to hide and unhide sheet according to drop down list
 
Join Date: Apr 2017
Posts: 1
aster is on a distinguished road
Default 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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to hide and unhide sheet according to drop down list 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
How to hide and unhide sheet according to drop down list Unhide and Re-hide in Excel 2003 thorgal67 Excel 1 07-16-2009 07:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:09 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft