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