Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
Corrections made to the above macro code: Sub HideWorkSheetsC() Dim wbA As Workbook Dim wsA As Worksheet Dim ceTa As String Dim ceTb As String Set wbA = Workbooks("Equip_List_FF.xls") For Each wsA In wbA.Sheets For Each cell In Workbooks("FF_ZoneBuildingEquipList.xls").Workshee ts( _ "ZONE 5 - BLDG LIST").Range("D4:D68") ceTa = Right(wsA.Range("A2").Text, 4) ceTb = Right(wsA.Range("C2").Text, 4) If ceTa = cell Or ceTb = cell Then GoTo nws Next cell wsA.Visible = xlSheetHidden 'xlSheetVisible nws: Next wsA End Sub jfcby |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to get rid/hide #NUM! error in Excel 2003? | Excel Worksheet Functions | |||
How to hide zero values in graphs using Mircosoft excel 2003? | Charts and Charting in Excel | |||
How do I hide and unhide worksheets in Excel 2007? | Excel Discussion (Misc queries) | |||
how do I hide data elements in pivot in excel 2003 ? | Excel Worksheet Functions | |||
Excel 2003 Hide PivotItems | Excel Worksheet Functions |