View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JJ[_10_] JJ[_10_] is offline
external usenet poster
 
Posts: 7
Default trapping Print events in VBA

Hi,

I'm trapping the App_workbookbefore Print Event which is working
wonderfully!

See http://www.cpearson.com/excel/AppEvent.aspx

But The Question I've got is it possible to return what sheet, if only
one sheet is printed or sheets if multiple sheets are printed.