View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.printing,microsoft.public.excel.programming,microsoft.public.excel.newusers
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default HELP: print macro woes :S

Are you using file, print when you record the macro.
Make sure your printer is set correctly during use of file, print.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"KevinGPO" wrote in message ...
Yep. Tried that thanks. Nothing gets recorded in the macro. It could be
something me doing not right.


:S
"tfoster" wrote in message
...
Hey Kevin! I know it is a week later, but have you thought of selecting
File-Print through a macro that you create? This will surely take care
of
your problem...

"KevinGPO" wrote:

I find that the 'print' macro immediately calls the default printer in
EXCEL
but it opens the Printer selection dialog window in WORD. How can one
stop
the PRINT button from selecting the default printer? Surely, it can open
the Printer selection window?