K. Georgiadis
10-04-2006, 07:23 AM
I have done this successfully with toggle switches but I am having a mental block when linking it to a variable cell:
In a workbook containing multiple sheets, this applies to a specific worksheet only;
Cell G17 is a variable, expressed in $ per pound
Upon entering 0 (zero) in G17, I want to hide Rows 17:19 and Row 54
If the value entered in G17 is anything above zero (there will be no negative numbers), I want the above mentioned rows to remain unhiddenYour help is greatly appreciated.
In a workbook containing multiple sheets, this applies to a specific worksheet only;
Cell G17 is a variable, expressed in $ per pound
Upon entering 0 (zero) in G17, I want to hide Rows 17:19 and Row 54
If the value entered in G17 is anything above zero (there will be no negative numbers), I want the above mentioned rows to remain unhiddenYour help is greatly appreciated.