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
|