How to catch Ctrl+P short or Pressing Print Button

[RobertS]

Hi,

I need to control when user will press Print Button or press Ctrl + P
combination to run separate procedure which will Save Excell file in
some place on the drive. Can you help me with such problem? Will be
appreciate.

Best regards

Robert

 

[Tom Ogilvy]

Look at the BeforePrint event.

If you are not familiar with evens, see Chip Pearson's overview at
http://www.cpearson.com/excel/events.htm

 

[Gord Dibben]

In Thisworkbook module.........something like this?

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs FileName:="C:\someplace\" & _
ActiveWorkbook.Name
' ActiveWorkbook.Save ' optional
Application.DisplayAlerts = True
End Sub


Gord Dibben MS Excel MVP