View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JON-JON JON-JON is offline
external usenet poster
 
Posts: 14
Default Problem - Workbook_BeforePrint

HELLO VB EXPERTS,

It seems that Workbook_BeforePrint event is triggered by both PrintOut and
PrintPreview. Is it possible that I could run a different code for each of
the command the user will choose. somewhat like:

Private Sub Workbook_BeforePrint

If user choose PrintOut Then
My code goes here
Else
My other code goes here
End If

End Sub

Anyone who could give light to my problem will be highly appreciated

Thanks in advance,

Jon-jon