Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

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

Re: Hiding empty rows before printing..

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?

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.