View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
EricG EricG is offline
external usenet poster
 
Posts: 220
Default application.run on new sheets created

Two things come to mind, one simple, one strange:

First, are you sure events are firing at all? A lot of times I forget that
I stopped some code after a "Application.EnableEvents = False" and then get
frustrated when stuff doesn't run.

Second, I discovered that using the "Insert/Worksheet" menu item causes the
Workbook_NewSheet event to fire, but control-dragging to create a new sheet
by copying an existing one doesn't! That's the strange part, and I could not
find a workaround. Is that what you are doing?

HTH,

Eric

"J.W. Aldridge" wrote:

macros are located in the same workbook.
still not firing.
i actually have 3 macros / procedures i need to fire on the creation
of a new worksheet.
just can't seem to get them to fire.
.