What is the macro command (code) to just open the Print dialogue box
without printing?

I tried this macro ExecuteExcel4Macro
"PRINT(2,1,1,1,,,,,,,,2,,,TRUE,,FALSE)" but it printed the worksheet.

Than kyou.

Maybe this:

Application.Dialogs(xlDialogPrint).Show

Regards,
Per

"Salza" <(E-Mail Removed)> skrev i meddelelsen
news:a1f2a01f-c8d8-40f4-b1ea-(E-Mail Removed)...
> What is the macro command (code) to just open the Print dialogue box
> without printing?
>
> I tried this macro ExecuteExcel4Macro
> "PRINT(2,1,1,1,,,,,,,,2,,,TRUE,,FALSE)" but it printed the worksheet.
>
> Than kyou.

On Mar 8, 3:13*pm, "Per Jessen" <per.jes...@mail.dk> wrote:
> Maybe this:
>
> Application.Dialogs(xlDialogPrint).Show
>
> Regards,
> Per
>
> "Salza" <zainudd...@gmail.com> skrev i meddelelsennews:a1f2a01f-c8d8-40f4-b1ea-(E-Mail Removed)...
>
> > What is the macro command (code) to just open the Print dialogue box
> > without printing?
>
> > I tried this macro *ExecuteExcel4Macro
> > "PRINT(2,1,1,1,,,,,,,,2,,,TRUE,,FALSE)" but it printed the worksheet.
>
> > Than kyou.


Hi Per,

Thank you. It works perfectly.

Regards,
Zainuddin