View Full Version : Solved: Hide worksheets
mprochello
12-13-2010, 10:48 AM
I would like to use vba to hide a worksheet based upon a value entered via dropdown list on another worksheet within the workbook. How can this be done?
Thanks for your assistance!
Bob Phillips
12-13-2010, 11:10 AM
If Worksheets("Sheet1").Range("A1") = "some value" Then
Worksheets("Sheet2").Visible = xlSheetHidden
Else
Worksheets("Sheet2").Visible = xlSheetVisible
End If
mprochello
12-14-2010, 08:52 PM
Thanks!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.