Yes I am. Am not wanting the worksheet to be printed. I just want the
command to display the Print Options/Dialog window.


"David McRitchie" wrote in message
...
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?