macro printing question

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

Guest

Hi,
I've created a macro that basically prints the same worksheet but with
different names on it. This was created for a friend to use at her work but
they use a different printer than what I use at home so it won't print when
she runs the macro at work.
The person this was created for does not know how to edit the macro to
change this. I do not have access to her computer so I was wondering if there
is a way that the macro can be edited to use her work computer's default
printer instead of it trying to use mine.
thanks, Pete
 
Pete

Post the code for us to be sure as if you set the printer in code there may
be an issue but

Worksheets(1).Printout

With no other parameters should print to the default printer

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
 
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

Epson XP-3150 not printing 2
Any link between malware and scam calls? 2
Unsolicited Emails 12
Print macros don't work on all printers 4
IPad remote 10
Print Macro Help 1
Print workbook tabs based on a selection list 1
Printing Problem In Excel Due to Macro? 4

Back
Top