Print before close

R

Renato8

Hi, I want to know if it is possible to print a page if it was not print
before close the file.

I dont know if a macro can advise to the user that want to close the
file, that the information in a sheet is not print yet.

Thanks

REnato
 
K

kassie

You can write a Before_Close event to print a preset print range, or else use
a messagebox to inform the user.
 
D

Dave Peterson

There's nothing built into excel that will tell you if a specific worksheet was
printed. You could try to do something to keep track if anything was
printed--or even just add a "did you remember to print your report" before the
workbook closes.

But as a user, I'd rather not get that warning each time. I'd rather just have
to reopen the workbook to print when I forgot.

On the other hand, if the sole purpose of opening the file is to print a
specific worksheet, you could have a macro that asked what files should be
opened and print the worksheet(s) that you want--with not too much user
intervention.
 
Top