ExcelBanter - open print dialog (File --- Print...)

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - open print dialog (File --- Print...) (https://www.excelbanter.com/excel-programming/351096-open-print-dialog-file-print.html)

snaggy^^

open print dialog (File --- Print...)

How can i do that by VBA? I just want to get the print dialog of the sheet2...
seems easy but i can't figure it out

bye

Dave Peterson

open print dialog (File --- Print...)

Worksheets("Sheet2").Select
Application.Dialogs(xlDialogPrint).Show

(not the File|page setup dialog, right?)

snaggy^^ wrote:

How can i do that by VBA? I just want to get the print dialog of the sheet2...
seems easy but i can't figure it out

bye

--

Dave Peterson

All times are GMT +1. The time now is 12:43 PM.