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.
.
|