Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Disallow Changing of Worksheet Name (Excel 2002)

    Hi!
    How would I go about disallowing other users of a worksheet from changing a name of a particular worksheet?
    Thanks!
    Lana

  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: Disallow Changing of Worksheet Name (Excel 2002)

    You can protect the workbook (Tools - protection - protect workbook)

    This will prevent any sheets from being renamed. If you want to allow renaming other sheets, you could create code to do this.

    Steve

Posting Permissions

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