MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hiding empty rows before printing..


Posted by newbie on August 03, 2001 11:36 AM

Hi again guys..


Need your help again..I got my data from A1:E100..
It is filled with colour , formula and border..
Let say..sometimes I just use only from A1:E50..
So..is there any macro which can detect the empty rows and hide it..so when I
print it..I dont want the border to appear..
the formula is ok..it show nothing..coz no data filled

ps: the empty rows still contain formula and border thats why i can't delete it..


Thanks in advance


Posted by Mark W. on August 03, 2001 11:54 AM

I'd like a password prompt to come up when a macro button is pushed, and ask the user to try again if the wrong password is entered, up to 3 times.

Can someone demostrate code to do this? Is the "up to 3 times" part possible?