VBA code to invoke the Print dialog box.

  • Thread starter Thread starter lothario
  • Start date Start date
L

lothario

Hi,

I need some VBA code that invokes the Print dialog box.

I cannot use the Printer icon in Excel to do this because
every time the users need to print the current spreadsheet
they first need to do a backup. They always remember to
get a printout (they need the hard copy) but they forget
to do a backup. This spreadsheet is updated with realtime
data several times each hour so a backup is necessary.

I have already implemented the VBA code in a button
to do the respective backup.

This button has the label "Do Backup".

Now I would like to add a few lines of VBA code to the
same button so that AFTER the backup is done the Print
dialog box shows up.

The button label would then be changed to
"Do Backup and Print ..."

Can you give me a few lines of VBA code that I can
append to do this?

Thanks,
Luther
 
In case anyone is interested, one possible answer is:

Application.Dialogs(xlDialogPrint).Show
 
Hi Luther,

I would recommend calling your backup data routine from the
Worksheet_BeforePrint event. To do this, just double-click the worksheet
icon in the VBE and add the following code:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
YourBackupRoutine
End Sub

That way, you can just back up the workbook each time the user prints (no
matter how they got there).

--
Regards,

Jake Marx
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
I would recommend calling your backup data routine from the
Worksheet_BeforePrint event. To do this, just double-click the
Click to expand...

Sorry - should have been Workbook_BeforePrint. Sorry for the confusion.

--
Regards,

Jake Marx
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
Back
Top