VBA not working

[Peterino]

My goal is to have the first page set as a template which would be applied to any additional sheets added to the book.
So far I tried to set a code to name the Sheet after A5. This is the code I found online. It was working at the start but not now. I could use a bit of assistance. Thanks. Peter

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

Could also use this line

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

[Logit]

.
Rather than the Sheet Level module, here is another project using a regular module :

Please Login or Register  to view this content.

[Peterino]

Logit: The bottom part of the code is for the sheet name to equal "A5" but it doesn't want to work. I saved the file first. Do I need to run something?

Peter

[AB33]

Did you try my code?

[Peterino]

Yes, I just hadn't responded on yours yet. Your code works fine. The second response from Logit included a button to add additional sheets with the same layout. The button works but the sheet name "A5" doesn't.
Sorry to refer to another person's post. Still stuck.

[Logit]

.
Strange. It works here as written in the sample workbook posted.

Did I misunderstand your goal ? You have a TEMPLATE sheet. In A5 you enter the name of the sheet to be created by the TEMPLATE macro.
The sheet is created and the tab has the name that was entered in A5 on the TEMPLATE sheet.

???

[jeffreybrown]

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about proper thread titles and adjust accordingly...
• Please see Forum Rule #2 about the proper use of code tags...

[Peterino]

Hello Jeffrey. I want to make the adjustments but would you mind providing more clarity as to which part of the rule(s) you are referring to?

[jeffreybrown]

Both the code tags in your first post and the thread title.

Edit: I added the code tags in your first post.

[Peterino]

I think I know why then. I was entering the sheet name in A5 thinking the template sheet would change. My bad. It works great!! Much appreciated.

[Logit]

.
You are very welcome.