Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro printing question
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro printing question
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 DTHIS www.nickhodge.co.uk "Pete W." <Pete wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I email amacro? | Excel Worksheet Functions | |||
Macro question | Excel Worksheet Functions | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Bob Phillips followup question on text macro | Excel Discussion (Misc queries) |