Embedded button print macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i'm trying to program a button to print selected worksheets from an excel file:

Private Sub CommandButton1_Click()
Range("Summary!, 'IRR Summary'!, 'Presentation Cash Flow'!, 'Rent Roll'!,
Vacancy!, 'Economic Rent'!").Select
ActiveWindow.ActiveSheets.PrintOut Copies:=1, Collate:=True
End Sub

luch to anyone in the LA area who can help me out!!!
THANKS
 
something like:

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).PrintPreview

Regards

Trevor
 
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

Hidden sheet bleeds through 3
Excel VBA - Problem with Closing Print Preview 0
Print macro help 3
Printing worksheets 3
Error Message - Macro to Unlink MS Queries from Workbook 0
Printing Macro 1
Command Button 6
Printing Macro 4

Back
Top