Prevent renaming of sheet

[Drmwvr7266]

Is there a simple effective way to prevent renaming of a sheet? Obviouly if I hide the tabs, that keeps those with basic knowledge locked out. But If I keep those tabs visible, is there a VB way?

 

[Mark W.]

Protect the workbook.

 

[Drmwvr7266]

Can't without locking out other functions already in place.

 

[Juan Pablo González]

You could disable the menu access, but, I'm not sure you can disable the doubleclick of the sheet tab.

 

[Mark W.]

On 2002-10-16 14:18, Drmwvr7266 wrote:
Can't without locking out other functions already in place.

Not true. Don't confuse protecting a Worksheet with protecting a Workbook. See the Excel Help topic for "Limit changes to an entire workbook".
This message was edited by Mark W. on 2002-10-16 14:26

 

[Tom Morales]

You could do something indirect and devious. Add some code that renames the sheet (with the same name) every time it is activated:

Private Sub Worksheet_Activate()
ActiveSheet.Name = "whatever"
End Sub

Tom

 

[Jack in the UK]

Hi

Try this - bit of fun will change the tab name in sheet one if changed once Excel re calculates. PROBABLY poor VBA script but will do as you ask, and will drive guys nuts for sure

Put in the sheet 1 module [edit as needed]
HTH

Jack


Private Sub Worksheet_Change(ByVal Target As Range)
If Worksheets(1).Name <> "Jack" Then
Worksheets(1).Name = "Jack"
End If

End Sub

 

[stevebausch]

Why are people so clueless as to protection/locking?

 

[Juan Pablo González]

Well, not everyone seems to know Excel as much as you do :wink:

 

[stevebausch]

Okay, let me rephrase me question.

Why do so many dispute the possibility that correctly locking/unlocking cells, and protecting the worksheets/workbook will give the desired result?

Is this a "control issue"? Do people resent the concept that other's activities may need to be restricted?

Seriously folks, if your request sounds like a situation where the user's interaction must be restricted, please READ THE HELP FILES regarding locking/unlocking cells, and protecting worksheets/workbooks.

It is true that the most recent versions of Excel allow greater control over what is being restricted. So, maybe the simple answer is to get a copy of Excel XP 2002?