Funtion/Code to rename a sheet/tab

[teafan]

Is there a function to do this or only VB code?

[VBA Noob]

Only with VBA

Link may help

http://www.excelforum.com/showthread.php?t=619875

VBA Noob

[teafan]

how do you request to name the sheet with the contents of a cell from another sheet, for example - sheet2?

You could set up a template if you need to do it a lot

http://office.microsoft.com/en-us/ex...292861033.aspx

or maybe this event macro. Right click each sheet and select view code and paste in the below then Sheet will rename to value in A1

Please Login or Register  to view this content.

[teafan]

using the above code (sorry!)

[VBA Noob]

Is the value in sheet 2 a formula or a user entry

VBA Noob

[teafan]

a user entry

[VBA Noob]

Try this in sheet 2. Changes the first sheet to Sheet 2 cell A1 value

Please Login or Register  to view this content.

VBA Noob

[teafan]

didnt work... basically, im setting up a sales tracker at work and need a function which will allow other managers to input their staff into (for this example, sheet2) a sheet and it automatically updates all of the other sheets with these names, renaming the tabs also. Its the renaming the tabs bit im finding to be a nightmare!

[VBA Noob]

See example

VBA Noob

[teafan]

cheers, thats great!

what would i need to edit in that code to get that to work on upto ten sheets? I guess we're straying into "complicated" if i wanted to allow the user to constantly re-name a sheet, like if a staff member leaves, using a similar code?

[VBA Noob]

See if link is of use

http://www.excelforum.com/showthread.php?t=622471

VBA Noob

[teafan]

It almost works!

It allows me to contantly change the tab name of the tab with the VB code but it wont let me obtain the information for the tab name from a seperate sheet (eg - staff - this contains all of the staff members, a user would key their names into this and it would re-name each tab appropriately)

i was trying a B3='staff'B3 kind of thing with your code as thre base but - didnt work

[VBA Noob]

Can you post an example of your structure and highlight the cells the user changes and which sheet should change

VBA Noob

[teafan]

here you go

[VBA Noob]

Does this help

VBA Noob

[teafan]

totally!

thanks alot!

[VBA Noob]

Your welcome

VBA Noob

[teafan]

that code worked at first but now doesnt...

how would i go about changing the range to include other sheets (named Sheet1-Sheet10)?

the cells which control the tab names would be:

C10, f110 i10, L10, c14, f14, i14, L14, f18, i18