Thread: print event
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xlcharlie xlcharlie is offline
external usenet poster
 
Posts: 37
Default print event

I want my beforeprint event code to execute only when the user prints the
document, not when the user switches to print preview. I tried creating a
button that would call a procedure to disable events, switch to print
preview, then re-enable events, but the user can then print from print
preview without executing the code for the beforeprint event.