+ Reply to Thread
Results 1 to 3 of 3

Protect Worksheet Help!

Hybrid View

  1. #1
    Registered User
    Join Date
    01-18-2005
    Posts
    62

    Protect Worksheet Help!

    Dear all,

    I have a workbook of 5 worksheets and I want to protect only Sheet1 & Sheet2 that user can not delete or change sheet name. Other sheets user can do anything they want.

    Could anyone can help me.

    Thanks a lot!

    Nam

  2. #2
    cush
    Guest

    RE: Protect Worksheet Help!

    Protecting a sheet does not protect the sheet name. You have to protect the
    workbook if you want to protect the name shown on the TAB at the bottom.

    "lehainam" wrote:

    >
    > Dear all,
    >
    > I have a workbook of 5 worksheets and I want to protect only Sheet1 &
    > Sheet2 that user can not delete or change sheet name. Other sheets user
    > can do anything they want.
    >
    > Could anyone can help me.
    >
    > Thanks a lot!
    >
    > Nam
    >
    >
    > --
    > lehainam
    > ------------------------------------------------------------------------
    > lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615
    > View this thread: http://www.excelforum.com/showthread...hreadid=472858
    >
    >


  3. #3
    Registered User
    Join Date
    01-18-2005
    Posts
    62
    Dear Cush,

    My question is that user can not delete or change name of sheet1 & sheet2, the rest can be deleted or changed name and user can add more sheets.

    Thanks,

    Nam

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1