View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How to catch Ctrl+P short or Pressing Print Button

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

--
Regards,
Tom Ogilvy

"RobertS" wrote in message
ups.com...
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