Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Protect the name of a sheet? (Excel 2000)

    Is there a way to protect the name of a sheet from being changed. Note everything elase about the sheet would not be protected just protecting the name of the sheet from being changed.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Protect the name of a sheet? (Excel 2000)

    Try tools - protection - protect workbook

    though this will prevent other changes to the workbook also (inserting, deleting worksheets, etc)

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Protect the name of a sheet? (Excel 2000)

    That is the problem, protect the worksheet names without protecting the rest of a worksheet.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Protect the name of a sheet? (Excel 2000)

    This doesn't protect any of the workSHEETS. It only protects the workBOOK.

    If this is not an option to protect the workbook, what are you trying to accomplish by preventing the name from being changed. There might be some workarounds.

    Steve

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Protect the name of a sheet? (Excel 2000)

    The only way apart from protecting the structure of the workbook is to use VBA.

    one way is to have code like this:

    Option Explicit
    Dim bDisableEvent As Boolean

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If bDisableEvent Then Exit Sub
    bDisableEvent = True
    If Me.Name <> "test" Then
    Me.Name = "test"
    End If
    bDisableEvent = False
    End Sub
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Protect the name of a sheet? (Excel 2000)

    Oops sorry I didn't understand your first reply. Yes protecting the workbook structure works. Thank you!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •