Naming Tabs

[HarryGreenwood]

Hi all,

Currently I have a working module which activates sheets and renames them according to a table I have a user fill in prior to setting up the sheet.

After some thought I have realised that the amount of sheets they require is a variable that my module doesn't allow for (currently the maximum is 9).

I was wondering if it was possible to make the naming of the sheets dynamic, whilst all lead by one sheet, for example, I was considering maybe a button which adds a row to the table and then renames the tab "SpareX" X being the number of the spares.

Just sounding out some thoughts, as it sits my sheet works, just looking to add an extra level of versatility in the future.

Cheers.

[natefarm]

I'm not really sure what the question is. Yes, renaming the sheets is possible, but you already know that because you've done it. Whether with a button or just triggered by sheet activity is up to you.

[HarryGreenwood]

My VBA has a function to automatically add sheets.

I'm wondering if I can add some automation toward the naming of sheets as a new one is added.

[ELeGault]

Do you already have a function/sub to generate the name... if so..then you just need to add the sheet, tell it is the active sheet when adding and name it with the reference you wish -

Sheets.Add After:=ActiveSheet
ActiveSheet.Name = "SPAREnameFUNCTION/REFERENCE"

[Richard Buttrey]

Upload your workbook so that we can see your request in context.

[HarryGreenwood]

I was thinking that the end user will need to need to specify the name of the sheet, I could achieve this with an InputBox perhaps?

I'm just wanting the sheet to be as automated as can be, because the formulas on there are extremely sensitive.

[ELeGault]

Like Richard said you should add it, and then clarify how the sheet Name would come to be. How would your end user know to add/name it. If there is logic then it is likely something that an end user need not be in control of. But this is something that requires elaboration and a sample/example to view and work with.

Cheers