Print and Save worksheet MACRO

[jimbo1083]

Hi, does anyone know how to create a macro that prints a current worksheet? And also does anyone know how to create a macro that saves the excel document?

Is there a library of standard macros within Excel(1997 eddition)

 

[ChrisUK]

Here you go ..

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
ActiveWorkbook.SaveAs Filename:="C:filesexcelBook1.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False


All I did was to record a new macro using tools, macro, record new macro!

 

[hedrijw]

This will do both:

Sub PrintandSave()
ActiveWindow.SelectedSheets.PrintOut Copies:=1
ActiveWorkbook.Save
End Sub

Try recording macros!