software

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: www.excelforum.com/member.php...oamp;userid=30604
View this thread: www.excelforum.com/showthread...hreadid=537276You can write a Before_Close event to print a preset print range, or else use
a messagebox to inform the user.

quot;Renato8quot; wrote:

gt;
gt; Hi, I want to know if it is possible to print a page if it was not print
gt; before close the file.
gt;
gt; I dont know if a macro can advise to the user that want to close the
gt; file, that the information in a sheet is not print yet.
gt;
gt; Thanks
gt;
gt; REnato
gt;
gt;
gt; --
gt; Renato8
gt; ------------------------------------------------------------------------
gt; Renato8's Profile: www.excelforum.com/member.php...oamp;userid=30604
gt; View this thread: www.excelforum.com/showthread...hreadid=537276
gt;
gt;

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 quot;did you remember to print your reportquot; 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:
gt;
gt; Hi, I want to know if it is possible to print a page if it was not print
gt; before close the file.
gt;
gt; I dont know if a macro can advise to the user that want to close the
gt; file, that the information in a sheet is not print yet.
gt;
gt; Thanks
gt;
gt; REnato
gt;
gt; --
gt; Renato8
gt; ------------------------------------------------------------------------
gt; Renato8's Profile: www.excelforum.com/member.php...oamp;userid=30604
gt; View this thread: www.excelforum.com/showthread...hreadid=537276

--

Dave Peterson