PRINT AREA QUESTION

[JonRowland]

Does anybody know if you can set Excel 97 to not print the first row.

My current spreadsheet has macro buttons in the first row but when I print I don't want this to print off. I don't really want to set a print area as my file changes constantly and I'd be changing forever the print area.

Many thanks
Jon

 

[OHIOCOWBOY]

You can uncheck the print property of the button and they will not print or change the print range to exclude the first row.

 

[JonRowland]

Unchecking the print property still leaves an ugly first row. I'm looking for a simple solution to help other users.

Cheers

Jon