Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2001
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting on unlocked cells in protected sheet (Excel 97/SR2)

    I have unlocked some cells for data entry and protected the worksheet with password.
    I want to allow users of the spreadsheet to be able to do formating, adding comments, etc on the unlocked cell.
    Anyone can enlighten me?

    How do I give the user a spreadsheet that

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting on unlocked cells in protected sheet (Excel 97/SR2)

    You can not change the format on a protected sheet. If there are specific things that you want to allow, then you would have to write VBA code to unprotect the sheet, make the format changes, the re-protect the sheet.
    Legare Coleman

Posting Permissions

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