Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Print button in Excel

Comment:

I have the following program to add to a button to print a sheet in Excel: Private Sub CommandButton1_Click() Sheets("Sheet2").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End Sub However, after I print I return to the printed sheet, and I would like to return to the sheet I printed from instead, how do I do that?

Name: jon_k
Date: July 21, 2009 at 06:26:14 Pacific

Reply:

Private Sub CommandButton1_Click() sheets("sheet2").printout End sub

0

How to Move Directory Wit...

1 Click Data entry

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: How can I create a print button in excel so that the user by clicking it will get the whole document printed? BUT The page must not have any background colour on it, nor should the links being seen. O...

Summary: i want to create a button in excel that will clear the contents of the row without deleting the formulas ...

Summary: Forgive me i'm thick when it comes to Excel. I Need some help creating a button in a spread sheet that i have, so when i click on it, it will add 1 to the number in the next cell. I.E if Number is 1 w...