Printing

S

smith.james0

Is there any way of getting my computer to automatically print a work
sheet everyday?

James
 
S

smith.james0

I have got it to open the file. I just don't know how to get it to prin
:confused
 
A

anilsolipuram

this will automatically print the excel sheet whenever the excel
workbook is opened, you to copy this code in "this workbook" at vba
editor, save it and close it.Now whenever the file is opened, it
prints.


Private Sub Workbook_Open()
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End Sub
 
S

smith.james0

Do i click on the work sheet i want to print, as there is six sheet
containing about 50 ish pages :) I only need to print work sheet
 
A

anilsolipuram

I am assuming that Sheet6 is the name of sheet 6, change the name if it
is different than that.

you have to copy this code in "this workbook" at vba editor, save it
and close it.Now whenever the file is opened, it prints sheet6.



Private Sub Workbook_Open()
Sheets("Sheet6").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1
end sub
 
A

abcd

also try
(Sheet6 is supposed to be the VBA name of the sheet, this way you can
change the name of the sheet)

Private Sub Workbook_Open()
Sheet6.PrintOut Copies:=1
end sub
 
Top