Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding/Unhiding Rows Automatically
I think I need a Macro which accomplishes the same task: as the following
formula would, except I cant find a HIDE or UNHIDE function to include in a formula. =IF(B24=4, UNHIDE Rows 10-25, IF(B24<4, HIDE Rows 10-25)) The Protected Workbook / Worksheet should OPEN with Rows 10-25 HIDDEN, but with Macro running. If at any time B24=4, it should UNHIDE Rows 10-25 If at any time B24<4, it should HIDE Rows 10-25 The Macro needs to be imbedded in the Workbook so that it automatically runs regardless of who opens the workbook. Can you help write this Macro, or suggest another method of accomplishing the same thing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
1004 Error when hiding/unhiding rows | Excel Discussion (Misc queries) | |||
hidden rows but not from hiding/unhiding? | Excel Discussion (Misc queries) | |||
unhiding and hiding rows | Excel Discussion (Misc queries) | |||
Hiding/unhiding rows | Excel Discussion (Misc queries) | |||
hiding/unhiding rows & columns with "+" and "-" buttons | Excel Discussion (Misc queries) |