View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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
.

.

.