Macro that adds entry into a list

[pyclen]

Hi therei appreciate any help I was provided already and may be provided now.

My question is a general question about a macro that can add a new entry into a list of tabs when a new tab is created or an existing duplicated.

I have a Menu tab with a list of tabs in my workbook, and have to manually enter the new tab that is created or was duplicated.

In other words my list is
Tab1
Tab2
Tab3
Tab4

So, when I create tab 5 I would like to get it added i would like to have it added automatically to the list.

 

[Micron]

You can trap when someone adds a sheet (NewSheet event) but I have not found a way to trap that someone has changed its name. So what happens in the list when "Sheet8" is added but they change the name to something else?

 

[pyclen]

Hi there,
Thank you for your reply however I have no idea what you mean by trap however the name update is also needed ( in a separate macro????)

 

[Micron]

by "trap" I mean catch/realize/know when something happens (an event) and have code do something.
NewSheet event is how you can trap for the addition of a new sheet. In the meantime I've read that there is no 'sheet name change' event but the question has been asked and answered elsewhere. I Googled

ms excel event when worksheet name is changed

and got a few. Maybe try that and see what you find that you can use. Here's one:

Rename Worksheet Event in Excel

What is the best way to get some VBA code to run when a excel sheet is renamed?

stackoverflow.com