I use a macro to automatically print or e-mail a workbook:
Application.OnTime TimeValue("06:55:00"), "Print_Out",
where "Print_Out" is a macro that actually does the printing:
ActiveWindow.SmallScroll ToRight:=-1
ActiveWindow.SmallScroll Down:=-1
Range("B2:P32").Select
ActiveWindow.SelectedSheets.PrintOut , Collate:=True
The problem is that I get multiple copies of the same book, but I have specified only 1 in the print macro. It does the same thing when I e-mail, it spits out say 4 copies of the same thing.
Any help is so greatly appreciated !
This message was edited by sparks on 2002-03-23 06:25
Application.OnTime TimeValue("06:55:00"), "Print_Out",
where "Print_Out" is a macro that actually does the printing:
ActiveWindow.SmallScroll ToRight:=-1
ActiveWindow.SmallScroll Down:=-1
Range("B2:P32").Select
ActiveWindow.SelectedSheets.PrintOut , Collate:=True
The problem is that I get multiple copies of the same book, but I have specified only 1 in the print macro. It does the same thing when I e-mail, it spits out say 4 copies of the same thing.
Any help is so greatly appreciated !
This message was edited by sparks on 2002-03-23 06:25