Printing another sheet

Hi


So you want to print sheet 2 from a button in sheet1?

If so

Just record a macro from sheet1 of what you want i.e printing / print settings etc:

To start a macro
Tools > Macro > Record New Macro...
then to stop
Tools > Macro > Stop Recording...

When you are done just use the autoshapes function to draw a button.
Right click on the auto shape and there should be a function to assign a macro to it. Assign your recorded macro to it and you are done.

If you just want to print without chnaging the sheet it should look like the below:

Sub printsheet2()
'
' printsheet2 Macro
' Macro recorded (Date) by (User)
'

'
Sheets("Sheet2").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub

Hope it helps

Hi


Put theis in your macro as the only way i know around it is to hide and unhide the sheet in your code

Sheets("Sheet2").Visible = True
Sheets("Sheet2").Visible = False

so your code should look something like this

Sub printsheet2()

Sheets("Sheet1").Select
Sheets("Sheet2").Visible = True
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Sheet2").Visible = False
Range("F11:F12").Select
Range("F12").Activate
Sheets("Sheet1").Select
Range("E19").Select
End Sub

hope it helps