VBA : xlDialogPrint function

G

Gilbert Aponte

I am using the following code to print:

Private Sub PrintButton_Click()
Application.Dialogs(xlDialogPrint).Show
ActiveCell.Range("F66").Activate
Range("A1").Select
Application.StatusBar = False

When the dialog screen is displayed I want to disable the
preview feature with the dialog box. What happens is when
the user select this function, my vb macro freezes up and
so does access to my workbook.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

xlDialogPrint 9
How to read settings from xlDialogPrint 1
application.dialogs(xlDialogPrint) - arguments 0
Print page one of sheet only 4
Problem w/ Print Macro 3
Help to amend code which prints only certain sheets 3
Pass a Function Value thru several Subs 1
Print dialog : problem when user click printpreview 6

Top