Automatically unhide rows

[marlinam]

1st, is it possible to set up Excel 07 to automatically unhide a row if there is an amount showing in one of its cells?

I have workbook where Worksheet 1 acts as my final accounting form. Because it has 963 rows, most of them are hidden when I print out my form (which will fit on a 8 1/2 x 11 portrait.

Worksheets 2-26 (27 organization/fund numbers + 37 different accounts within each org/fund) hold the actual numbers and are linked to W1.

What I want is for the hidden rows in Worksheet 1 to unhide themselves when an amount shows up in W2-26.

I'm relatively new, so I don't know much about formulas and if/then statements.

Thanks!

[Richard Buttrey]

Hi, and welcome to the forum

You'll need some VBA code to do this. One way:

Please Login or Register  to view this content.

That will run when you choose to run it. To have it run automatically you could attach it to another (say) print macro, or on a workbook save event or something similar.

HTH