printing non active excel sheets

superchew, if you have this on an auto_open macro, just schedule the sheet in the windows task scheduler? If the sheet is closed then some other program or macro will have to open it. Assuming you mean the workbook with the sheet is not open. If the workbook that contains the sheet IS open, then it is different.

What version of windows?

You can name a macro "sub auto_open()"
That makes it run as soon as the workbook is opened.
then the macro can run the sheet and close the workbook.
By making windows open the sheet from the task scheduler (in control panel, i can give you better directions with you version) it would/could run every day.

i have a sheet that counts days without an injury. is there a way to have that sheet print everyday even if it is not open?

No, you cannot print a sheet if the workbook is not open. It is fairly easy to write code to open a workbook, print a particular sheet and then close the workbook if that's what you need.

HTH

Robert

superchew,

If you put the print macro and a line of code to close the workbook in a macro called auto_open as mentioned before, then you can have it print every day, and close itself after printing. Then in the control panel in windows, go to administrative tools, and then Task Scheduler. Select Create Task on the right, and under the Actions tab you can click new, then add your excel sheet. Under the Triggers tab you can set it up to run daily, and you can specify the time.