Prevent renaming of sheet

Drmwvr7266

Board Regular
Joined
Apr 7, 2002
Messages
164
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?
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654

ADVERTISEMENT

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

Board Regular
Joined
Feb 16, 2002
Messages
91
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

Well-known Member
Joined
Feb 16, 2002
Messages
3,215

ADVERTISEMENT

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

Well-known Member
Joined
May 11, 2002
Messages
810
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?
 

Forum statistics

Threads
1,144,326
Messages
5,723,724
Members
422,512
Latest member
MHau5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top