ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA : xlDialogPrint function (https://www.excelbanter.com/excel-programming/279568-vba-xldialogprint-function.html)

Gilbert Aponte[_2_]

VBA : xlDialogPrint function
 
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.


All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com