run macro after print command.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi to all
Is there any way when i print a worksheet after print command given from
file menu it should run a macro or it should ask the name of macros which
have in module.

thanks

shital shah
 
there is a Before Print event in the worksheet module but
no after print so no you can't do that.
I would suggest that you assign your macro to a custom
icon that you can click just after print.
 
=?Utf-8?B?c2hpdGFsIHNoYWg=?= wrote
Is there any way when i print a worksheet after print command given
from file menu it should run a macro or it should ask the name of
macros which have in module.
Click to expand...

Maybe this will work:

Worksheet Module
Private Sub Workbook_BeforePrint(Cancel As Boolean)
On Error GoTo Quit
Application.OnTime Now(), ThisWorkbook.Name & "!WorkbookAfterPrint"
Quit:
End Sub

General Module
Sub WorkbookAfterPrint()
'Your code or call macro here
End Sub
 
Back
Top