Does anyone know how I can protect a worksheet from being renamed by
the user without stopping him/her from amending (or adding) values to
that worksheet?

All I want to do is to stop renaming!

Don't know if it's the most efficient way, but I have achieved this by:

1) turning off the ribbon (this is in Office '07, there is a similar
capablity with earlier versions);
Private Sub Workbook_Open()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"

2) disable right-click functionality
Private Sub Workbook_Open()
Application.CommandBars("Ply").Enabled = False

3) lock and protect all sheets

I'm no programmer, but was able to do build a VBA solution by searching
through these forums for similar problems & solutions and adapting them.

HTH

Dave


"JAC" wrote:

Does anyone know how I can protect a worksheet from being renamed by
the user without stopping him/her from amending (or adding) values to
that worksheet?

All I want to do is to stop renaming!

Hi Jac

Protect the workbook


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JAC" wrote in message ...
Does anyone know how I can protect a worksheet from being renamed by
the user without stopping him/her from amending (or adding) values to
that worksheet?

All I want to do is to stop renaming!

If your reason for wanting this is that renaming worksheets stops your VBA
code working try using Worksheet.codename in your code rather than
Worksheet.Name.

Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"JAC" wrote in message
...
Does anyone know how I can protect a worksheet from being renamed by
the user without stopping him/her from amending (or adding) values to
that worksheet?

All I want to do is to stop renaming!