Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.printing,microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.printing,microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
HELP: print macro woes :S
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? |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.printing,microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
HELP: print macro woes :S
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? |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.printing,microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.printing,microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
HELP: print macro woes :S
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? |
#6
Posted to microsoft.public.excel.misc,microsoft.public.excel.printing,microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
HELP: print macro woes :S
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. |
#7
Posted to microsoft.public.excel.misc,microsoft.public.excel.printing,microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
HELP: print macro woes :S
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. |
#8
Posted to microsoft.public.excel.misc,microsoft.public.excel.printing,microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
HELP: print macro woes :S
Thanks for the correction, don't know why I dropped the last part
"JNW" wrote ... should read application.dialogs(xldialogprint).show |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP: print macro woes :S | Excel Discussion (Misc queries) | |||
HELP: print macro woes :S | New Users to Excel | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Macro to open print window and set to print entire workbook | Excel Discussion (Misc queries) | |||
Need Help w/ Print Macro to Print All Visible Sheets (including Charts) in a Workbook | Excel Programming |