How do I set up worksheet tabs to change based on a workbook cell

L

LJVG

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.
 
O

Otto Moehrbach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect Workbook 4
Excel 2003 - how to check is all worksheet is protected 1
How to get range names to Apply across multiple tabs 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
How do I remove a forgotten password from an Excel Worksheet? 2
How do I move multiple tabs in multiple workbooks to a master? 3
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
Need Macro to Collect Multiple Worksheet Names 3

Top