View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carlos Cortes[_2_] Carlos Cortes[_2_] is offline
external usenet poster
 
Posts: 1
Default providing a sheet-copy event or copy CustomProperties

I just noticed that the NewSheet event doesn't actually get fired for sheet
copies. Only SheetActivate and SheetDeactivate are fired. This is an even
more limited situation than I depicted. My suggestion is still relevant, but
the potential to mess up existing applications is greater. Probably the best
thing to do would be to create a new Event handling sheet copy, move, and
rename as one event. But like I said the first fix is the easiest.

Thanks, Carlos