This code can be put either in the Workbook_Activate or
Workbook_SheetActivate sub, or so on, depending upon when you want it to
display.

-Chad

"Tanu Gulati" wrote:

well thanks for giving the hint for the below mentioned question, but i am
looking for printlng the document , in your code you have not mentioned where
i am instructing the computer to print and where i need to write the code
...please specify


"Chad" wrote:

try something like this:
Application.OnTime TimeValue("16:00:00"),
Application.Dialogs(xlDialogPrint).Show

hope this helps!
-chad

"Tanu Gulati" wrote:

i need to print an Excel document at 4:00 PM every day which is in LAN and
shared across by many people. i wanted this process to be automated. i mean
i
wanted that Excel should automatically give the print command at 4:00 PM
every day .
any solutions for this
i got one solution in terms of Ontime method in macro but can any body tell
me the how to code and the complete procedure for it .......i dont know which
parameters i need to pass in onTime method .
thanks
Tanu