HELP: print macro woes :S

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...

"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?

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?

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?

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?

Hi Kevin,

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


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...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=498305

Hi Kevin,

Application.Dialogs(xlDialogPrint)

http://archive.baarns.com/excel/faq/xd_dbox1.asp

changing parameters:
http://groups.google.com/group/micro...3e98aaa5d7b904

for examples and setting parameters use a Google search:
print dialog box sub excel
actually now you can improve that with
xldialogprint sub excel parameters
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

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

should read
application.dialogs(xldialogprint).show

"David McRitchie" wrote:

Hi Kevin,

Application.Dialogs(xlDialogPrint)

http://archive.baarns.com/excel/faq/xd_dbox1.asp

changing parameters:
http://groups.google.com/group/micro...3e98aaa5d7b904

for examples and setting parameters use a Google search:
print dialog box sub excel
actually now you can improve that with
xldialogprint sub excel parameters
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

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

Thanks for the correction, don't know why I dropped the last part

"JNW" wrote ...
should read
application.dialogs(xldialogprint).show