I have a protected workbook that has several worksheets. I'd like to let
users change the tab names from Sheet 1, Sheet 2, etc. to customize their
workbook and still keep the protection on the workbook structure. I realize
that users could set their tab names if I unprotected the workbook and just
protected the sheets, but we want to keep the workbook protected. Any ideas?
FYI I'm not a visual basic user but can get access to someone who is.

Your subject line says "...based on a workbook cell." but you don't mention
that in the body of your post. Is there one cell on each sheet that will
contain the name that you (or they) want to name the sheet? HTH Otto
"LJVG" wrote in message
...
I have a protected workbook that has several worksheets. I'd like to let
users change the tab names from Sheet 1, Sheet 2, etc. to customize their
workbook and still keep the protection on the workbook structure. I
realize
that users could set their tab names if I unprotected the workbook and
just
protected the sheets, but we want to keep the workbook protected. Any
ideas?
FYI I'm not a visual basic user but can get access to someone who is.