Event triggered when renaming sheet?

**twd000** · 09-29-2008, 07:08 PM

the user triggers the addin

it has a custom menu in the excel toolbar. by clicking through the menus and some dialog boxes, the user defines what type of Designed Experiment should be populated on the new sheet. Then the add-in creates that DOE experiment and populates the data onto the new sheet. finally the sheet is renamed at which point I want my code triggered to copy the data from the new sheet into various locations in other sheets

**shg** · 09-29-2008, 07:19 PM

You could shadow the button click event, and then start an OnTime procedure that checks the name of the sheet periodically (the first invocation may not run until the add-in is complete).

Or give the user another button to trigger your code.

Sorry, I don't have a better idea.

**twd000** · 09-29-2008, 07:56 PM

is the click event you refer to associated only with UserForms?

the addin doesn't use a UserForm, but instead some type of dialog box

does this click event work for these dialog boxes too?

**shg** · 09-29-2008, 08:18 PM

If you get the ID of a button (the add-in's button, in this case), you can process then event in your code as well -- I think . I don't do a lot of work with menus -- Andy Pope, RoyUK, or some others could do this in their sleep.

Given the number of exchanges in this thread, I'd suggest you start a fresh one, something like "Shadow click event for menu button"