I know you can pass protect a spreadsheet but does anyone know a way I
can pass protect a tab instead of the entire spreadsheet?


--
GGanders
------------------------------------------------------------------------
GGanders's Profile: http://www.excelforum.com/member.php...o&userid=35422
View this thread: http://www.excelforum.com/showthread...hreadid=551883

Are you trying to stop the tab being renamed?

If so, you could check it with the worksheet_deactivate event like so

Private Sub Worksheet_Deactivate()
If Me.Name < "Test" Then
MsgBox "You cannot rename this sheet to " & Me.Name & " renaming to
Test...", vbOKOnly
Me.Name = "Test"
End If
End Sub

If you try to exit the sheet with the name not set to Test, it will stop you
and rename it.

Deactivate may not be the correct event or the only one, but it may give you
a start

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"GGanders" wrote in
message ...

I know you can pass protect a spreadsheet but does anyone know a way I
can pass protect a tab instead of the entire spreadsheet?


--
GGanders
------------------------------------------------------------------------
GGanders's Profile:
http://www.excelforum.com/member.php...o&userid=35422
View this thread: http://www.excelforum.com/showthread...hreadid=551883

There are several types of protection.

1. Password to open the file. Can be set at FileSave AsToolsGeneral
Options.

2. Password on a protected worksheet. This is set at ToolsProtectionProtect
Sheet.

Many functions can be disabled using this type of protection.

3. Workbook Protection password. This is set at ToolsProtectionProtect
Workbook.

This protects the workbook from having sheets deleted and other functions
disabled.

4. VBA Project password to prevent viewers from looking at code modules.

NOTE: except for File to Open protection and VBA project passwords, most forms
of Excel protection are very weak and passwords can be easily cracked.


Gord Dibben MS Excel MVP

On Wed, 14 Jun 2006 10:08:21 -0500, GGanders
wrote:


I know you can pass protect a spreadsheet but does anyone know a way I
can pass protect a tab instead of the entire spreadsheet?

Gord Dibben MS Excel MVP