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.. there any macro which can detect the empty rows and hide when I
print it..I dont want the border to appear..
the formula is 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?