WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Problems with Print Macro

 
   Home -> Office -> Printing RSS
Next:  nique Value Macro requested  
Author Message
Jim

External


Since: Sep 11, 2004
Posts: 503



(Msg. 1) Posted: Thu Oct 30, 2008 1:46 am
Post subject: Problems with Print Macro
Archived from groups: microsoft>public>excel>printing (more info?)

I have created a small macro and assigned it to a button that selects a
number of worksheets and then prints these to the selected printer - 2
problems happen either -
- only first 5 pages of 12 come out on printer OR
- get error 1004

Macro code is -
==============================================
Sub Print3()
'
' Print3 Macro
'

'
Sheets(Array("MoM", "Development", "Delivery Schedule", "Incident
Management", _
"Defect Management", "Task Management", "Trends", "Financials", _
"Consultancy", "Active Customers", "Risks and Issues")).Select
Sheets("MoM").Activate
Application.Dialogs(xlDialogPrint).Show
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

Sheets(Array("MoM")).Select
End Sub
=========================================
Can anyone help? Thanks Jim
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> Printing All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET |
  • IT Support