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


--
Renato8
------------------------------------------------------------------------
Renato8's Profile: http://www.excelforum.com/member.php...o&userid=30604
View this thread: http://www.excelforum.com/showthread...hreadid=537276

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

"Renato8" wrote:


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


--
Renato8
------------------------------------------------------------------------
Renato8's Profile: http://www.excelforum.com/member.php...o&userid=30604
View this thread: http://www.excelforum.com/showthread...hreadid=537276

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.



Renato8 wrote:

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

--
Renato8
------------------------------------------------------------------------
Renato8's Profile: http://www.excelforum.com/member.php...o&userid=30604
View this thread: http://www.excelforum.com/showthread...hreadid=537276

--

Dave Peterson