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