+ Reply to Thread
Results 1 to 3 of 3

Unprotect Sheet suddenly greyed out

  1. #1
    Registered User
    Join Date
    08-28-2007
    Location
    Yorkshire, England
    Posts
    8

    Unhappy Unprotect Sheet suddenly greyed out

    I have protected a worksheet as it has several formulae on that I do not wat anyone else to mistakingly delete. I then have spent time on setting up a sheet to track changes (just in case this has any bearing on the problem). This is the only thing that I think I have changed since protecting this morning and now I cannot unprotect the sheet. I have not protected the workbook and the unprotect sheet function is now greyed out.

    Any ideas?

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    MS 2007, 2010
    Posts
    12,201
    Yes, you cannot unprotect the workbook while it's being shared. Under Tools>Share Workbook, the check box needs to be unchecked. Then you should be able to unprotect your workbook. Did that solve your problem?

    ChemistB

  3. #3
    Registered User
    Join Date
    08-28-2007
    Location
    Yorkshire, England
    Posts
    8

    Wink

    Thank-you. I had kept looking at the highlight and track changes method but couldn't see how to turn it off.

    Many thanks again!

+ 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