prevent user to rename sheet
 

Is there a way to prevent user to rename a sheet?
Thanks

prevent user to rename sheet
 

Hi
protect the workbook ('tools - Protection')

-----Original Message-----
Is there a way to prevent user to rename a sheet?
Thanks
.

prevent user to rename sheet
 

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?
-----Original Message-----
Hi
protect the workbook ('tools - Protection')

-----Original Message-----
Is there a way to prevent user to rename a sheet?
Thanks
.

.

prevent user to rename sheet
 

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.

-----Original Message-----
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?
-----Original Message-----
Hi
protect the workbook ('tools - Protection')

-----Original Message-----
Is there a way to prevent user to rename a sheet?
Thanks
.

.

.

prevent user to rename sheet
 

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)

"Frank Kabel" wrote in message
...
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.

-----Original Message-----
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?
-----Original Message-----
Hi
protect the workbook ('tools - Protection')

-----Original Message-----
Is there a way to prevent user to rename a sheet?
Thanks
.

.

.