SCENERIO:
I've created a one worksheet document that has 5 pages, one below the next (I used page breaks).
At the bottom of each page is a cell that holds an "if/and" argument designed to display a blank ("") in that cell if there is no other data on that particular page (the entire page will be blank).
The worksheet also contains a macro that turns the "fixed decimal" option on/off when the sheet opens/closes, so decimals are automatically entered (258 displays 2.58).
Everything works like a champ, but...
PROBLEM:
When I click the printer icon, the printer prints all 5 pages, even the ones left blank.
The users won't be able to use any kind of print set up...they'll just click the "print" icon.
I WANT:
I want the printer to ignore the blank pages.
I don't want to do anything but click the "print" icon.
Any macro has to turn itself on and off when the sheet opens and closes so it won't affect other excel documents.
An answer will bring together this little project that I designed to shave about 20 minutes of grunt work off of my coworker's day.
Thanks in advance for any help.
Digby67
I've created a one worksheet document that has 5 pages, one below the next (I used page breaks).
At the bottom of each page is a cell that holds an "if/and" argument designed to display a blank ("") in that cell if there is no other data on that particular page (the entire page will be blank).
The worksheet also contains a macro that turns the "fixed decimal" option on/off when the sheet opens/closes, so decimals are automatically entered (258 displays 2.58).
Everything works like a champ, but...
PROBLEM:
When I click the printer icon, the printer prints all 5 pages, even the ones left blank.
The users won't be able to use any kind of print set up...they'll just click the "print" icon.
I WANT:
I want the printer to ignore the blank pages.
I don't want to do anything but click the "print" icon.
Any macro has to turn itself on and off when the sheet opens and closes so it won't affect other excel documents.
An answer will bring together this little project that I designed to shave about 20 minutes of grunt work off of my coworker's day.
Thanks in advance for any help.
Digby67