prevent user to rename sheet

C

caroline

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?
 
F

Frank Kabel

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

Bob Phillips

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)
 
Top