Autoname Tabs by changing cell

[kc27315]

Is there a way to make the name of a Tab = the contents of a cell.

For instance if I type "Pizza" in cell B3, I want the current tab to be named "Pizza", but then if I change B3 to "Banana", I want the tab name to change to "Banana" as well.

Many thanks in advance for any help.

kc

[VBA Noob]

Maybe this event macro will help. Right click the sheet tab > select view code and paste in the below

Please Login or Register  to view this content.

VBA Noob

[kc27315]

It works great. Very easy to accomplish with your help. Thank you!

kc

[kc27315]

I actually wanted to have this work by referring to a cell on a different sheet. When I tried it, I couldn't get the names of the Tabs to change. I've attached a spreadsheet with my attempt. Can someone help me to get it to work? Thank you.

kc

[kc27315]

I forgot to attach the spreadsheet where I made my attempt.
Here it is.

[VBA Noob]

This assumes sheets tab's won't be moved...see if it helps

VBA Noob

[kc27315]

I opened your spreadsheet and saw the code by right-clicking on the Sheet1 tab. I typed "Pizza" in cell C6, and nothing happened. Am I supposed to have code in sheet 2?

[VBA Noob]

Should work. I can only guess your enableevents has being turned off so try this version

VBA Noob

[kc27315]

That's great

[VBA Noob]

Glad it helped

VBA Noob