| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to hide columns and/or worksheets
I need some help with a macro issue....
I have a spreadsheet with multiple worksheets in it, say "worksheet1" "worksheet2" "worksheet3" "worksheet4" I want to conditionally hide either columns or entire worksheets based on the value of a cell in Worksheet1 For instance: IF "Worksheet1.B17" is NULL Then Hide columns F:K on Worksheet2 and Hide Hide columns G:K on Worksheet3 and Hide Worksheet4 Any help would be greatly appreciated!!!!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a macro to hide certain columns | Excel Discussion (Misc queries) | |||
| I set up a macro to hide/unhide columns. It hides more columns | 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 | |||
| macro to hide rows across several worksheets fails | Excel Discussion (Misc queries) | |||
| Macro to hide Columns | Excel Programming | |||
![Ken K[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
