HELP: print macro woes :S

  • Thread starter Thread starter KevinGPO
  • Start date Start date
K

KevinGPO

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?
 
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...
 
Yep. Tried that thanks. Nothing gets recorded in the macro. It could be
something me doing not right.


:S
 
Are you using file, print when you record the macro.
Make sure your printer is set correctly during use of file, print.
 
Yes I am. Am not wanting the worksheet to be printed. I just want the
command to display the Print Options/Dialog window.
 
Hi Kevin,
Yes I am. Am not wanting the worksheet to be printed. I just want the
command to display the Print Options/Dialog window.
Click to expand...

I'm not sure if this exactly what you want but try:
1)
application.dialogs(xlDialogPrint).show 'opens the "Print
Options/Dialog window"
'found by searching "Built-In Dialog" in Excel's VB help.
or
2)
expression.PrintOut(From, To, Copies, Preview, ActivePrinter,
PrintToFile, Collate, PrToFileName)
'found by searching "print" in Excel's VB help.

I think 1) is what you are after.

hth,
Rob Brockett
NZ
Always learning & the best way to learn is to experience...
 
Back
Top