prevent user to rename sheet

  • Thread starter Thread starter caroline
  • Start date Start date
yes of course. SOrry I should ahve said that I cannot
protect the workbook because I want to be able to add
sheets. Is there a code I could use?
 
Hi
then it's getting difficult. You may consider protection
the workbook and creating a macro for sheet insertions.
This macro first unprotects the workbook, insertes the
sheet and the protect the workbook gain.
 
You might also want to consider why you don't want the sheets renamed. If it
is because your code refers to the sheet name, then use codename.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

To prevent a user from deleting and renaming a sheet in a workbook 3
Creating new sheet and renaming problem 2
Copy Sheet and rename it. 11
rename sheets(tabs) 10
Rename sheet with content in specific cell 4
Changing sheet name based on a cell in another sheet 1
Rename Sheets based on List 5
Renaming sheets - Performance problem 10

Back
Top