software

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-gt;Print through a macro that you create? This will surely take care of
your problem...

quot;KevinGPOquot; wrote:

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

Yep. Tried that thanks. Nothing gets recorded in the macro. It could be
something me doing not right.:S
quot;tfosterquot; gt; wrote in message
...
gt; Hey Kevin! I know it is a week later, but have you thought of selecting
gt; File-gt;Print through a macro that you create? This will surely take care
gt; of
gt; your problem...
gt;
gt; quot;KevinGPOquot; wrote:
gt;
gt;gt; I find that the 'print' macro immediately calls the default printer in
gt;gt; EXCEL
gt;gt; but it opens the Printer selection dialog window in WORD. How can one
gt;gt; stop
gt;gt; the PRINT button from selecting the default printer? Surely, it can open
gt;gt; the Printer selection window?
gt;gt;
gt;gt;
gt;gt;
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;KevinGPOquot; gt; wrote in message ...
gt; Yep. Tried that thanks. Nothing gets recorded in the macro. It could be
gt; something me doing not right.
gt;
gt;
gt; :S
gt; quot;tfosterquot; gt; wrote in message
gt; ...
gt; gt; Hey Kevin! I know it is a week later, but have you thought of selecting
gt; gt; File-gt;Print through a macro that you create? This will surely take care
gt; gt; of
gt; gt; your problem...
gt; gt;
gt; gt; quot;KevinGPOquot; wrote:
gt; gt;
gt; gt;gt; I find that the 'print' macro immediately calls the default printer in
gt; gt;gt; EXCEL
gt; gt;gt; but it opens the Printer selection dialog window in WORD. How can one
gt; gt;gt; stop
gt; gt;gt; the PRINT button from selecting the default printer? Surely, it can open
gt; gt;gt; the Printer selection window?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
Yes I am. Am not wanting the worksheet to be printed. I just want the
command to display the Print Options/Dialog window.quot;David McRitchiequot; gt; wrote in message
...
gt; Are you using file, print when you record the macro.
gt; Make sure your printer is set correctly during use of file, print.
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;KevinGPOquot; gt; wrote in message
gt; ...
gt;gt; Yep. Tried that thanks. Nothing gets recorded in the macro. It could be
gt;gt; something me doing not right.
gt;gt;
gt;gt;
gt;gt; :S
gt;gt; quot;tfosterquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hey Kevin! I know it is a week later, but have you thought of
gt;gt; gt; selecting
gt;gt; gt; File-gt;Print through a macro that you create? This will surely take
gt;gt; gt; care
gt;gt; gt; of
gt;gt; gt; your problem...
gt;gt; gt;
gt;gt; gt; quot;KevinGPOquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; I find that the 'print' macro immediately calls the default printer in
gt;gt; gt;gt; EXCEL
gt;gt; gt;gt; but it opens the Printer selection dialog window in WORD. How can one
gt;gt; gt;gt; stop
gt;gt; gt;gt; the PRINT button from selecting the default printer? Surely, it can
gt;gt; gt;gt; open
gt;gt; gt;gt; the Printer selection window?
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;
gt;

Hi Kevin,

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

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

I think 1) is what you are after.

hth,
Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=498305Hi Kevin,

Application.Dialogs(xlDialogPrint)

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

changing parameters:
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: www.mvps.org/dmcritchie/excel/excel.htm

quot;KevinGPOquot; gt; wrote ...
gt; Yes I am. Am not wanting the worksheet to be printed. I just want the
gt; command to display the Print Options/Dialog window.
should read
application.dialogs(xldialogprint).show

quot;David McRitchiequot; wrote:

gt; Hi Kevin,
gt;
gt; Application.Dialogs(xlDialogPrint)
gt;
gt; archive.baarns.com/excel/faq/xd_dbox1.asp
gt;
gt; changing parameters:
gt; groups.google.com/group/micro...3e98aaa5d7b904
gt;
gt; for examples and setting parameters use a Google search:
gt; print dialog box sub excel
gt; actually now you can improve that with
gt; xldialogprint sub excel parameters
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt;
gt; quot;KevinGPOquot; gt; wrote ...
gt; gt; Yes I am. Am not wanting the worksheet to be printed. I just want the
gt; gt; command to display the Print Options/Dialog window.
gt;
gt;
gt;

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

quot;JNWquot; gt; wrote ...
gt; should read
gt; application.dialogs(xldialogprint).show