excel how to put a print button in the document

  • Thread starter Thread starter Guest
  • Start date Start date
Two options:

1. View > Toolbars and check Standard
the Standard toolbar has a Print button it

2. put you own button in the worksheet with VBA:

Sub button_maker()
Application.CommandBars("Forms").Visible = True
ActiveSheet.Buttons.Add(290.25, 69, 51.75, 41.25).Select
Selection.OnAction = "printit"
Application.CommandBars("Forms").Visible = False
End Sub


Sub printit()
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub


The first sub creates a button. The second sub does the printing. This
assumes that the print range has already been established.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Possible to have various sections of worksheets print on 1 page? 1
Shade a Cell 7
Set non-continuous PrintArea via Function / Name 0
split print area in excel - One Page Print 3
How can we convert OST to PDF file format? 1
excel document with shapes on it but the shapes do not print 2
Show comments when printing a document 2

Back
Top