sorry, the code should only work when the manager presses the button - so if
we had a list of advisers: Simon, Daryl, Jakub, Barry and then George started
work, the manager would type George into the cell below Barry and click a
button. This would then rename the appropriate tab and that's it! There are
always ten CA tabs - never any more or less (i use a macro to hide these if
they are unused).

"Bernard Liengme" wrote:

You have ten worksheets named CA1 thru CA10
The manager will type a staff name into the worksheet Staff Details
Let's say he types "George"
Now what do you want to happen?
I may not be the one to answer the question, but as posed it is somewhat
unclear.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"teafan" wrote in message
...
Hi

I'm building a sales tracker for my company and need to create a function
where the "administrator" can rename a specific range of tabs according to
a
list of staff by clicking on a button.

There are ten "staff" tabs (named CA1 through CA10) which i need to
control
by the manager keying the name of the member of staff into a sheet called
Staff Details and then pressing a button to refresh the names. I simply
cannot figure out how to rename a sheet according to a central
reference...
anything i try will not work!