Re: $$Excel-Macros$$ Vba code to hide worksheets based on a cell value

Thank you, Ayush. This is exactly what I wanted. Regards Yahya On Sun, Feb 7, 2010 at 1:21 PM, ayush jain wrote: > Hi Yahya, > > Attached is the solution. Use the below code in ThisWorkbook code section. > > Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) > > Di

Re: $$Excel-Macros$$ Vba code to hide worksheets based on a cell value

Hi Yahya, Attached is the solution. Use the below code in ThisWorkbook code section. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If ws.Range("C1").Value = "0" Then ws.Visible

$$Excel-Macros$$ Vba code to hide worksheets based on a cell value

Hi I have a workbook which has a no of worksheets. I want to hide all those worksheets automatically, when the value of a particular cell (Say C1) in that worksheet is zero. Can someone help me with the code for it? Regards Yahya -- ---