Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide colum based on cell value on each worksheets
I have a workbook with several worksheets. I am trying to write a VBA
macro that would look at row 5 to see if any cells indicate "Hide column". If it does, it would hide all the columns indicating "Hide column" on this worksheet. Then it would continue the same process to the next worksheet, and the next one ... I currently have the macro working for the individual worksheet (see below), but I would like to have it work to do all the worksheets of the workbook. Sub HideColumn() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual For a = 5 To 200 If Range("A5").Offset(0, a).Value = "Hide column" Then Range ("A5").Offset(0, a).EntireColumn.Hidden = True Next a Application.ScreenUpdating = True Thanks in advance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide or display worksheets based on form | Excel Discussion (Misc queries) | |||
I am trying to lookup a cell based upon what is in row 3 and colum | Excel Discussion (Misc queries) | |||
Hide Worksheets based on value from Access DB | Excel Programming | |||
PROBLEM: hide/unhide worksheets based on cell value change | Excel Programming | |||
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel |