+ Reply to Thread
Results 1 to 2 of 2

Anyway to format a locked sheet?

Hybrid View

  1. #1
    Registered User
    Join Date
    03-28-2008
    Posts
    1

    Anyway to format a locked sheet?

    Is anyone aware if its possible to enable formatting options within a locked worksheet?

    Specifically, we'd like to allow the insertion of notes or the colouring of cells while leaving users unable to insert rows, columns, or change numerous formulaes.

    We are trying to prevent any changes to the sheet's structure which is subject to a number of users who are quite inexperienced with anything excel. Multiple sheets of this nature feed into a master workbook and we've experienced numerous structural problems over the past year so we've decided to lock each user's own worksheet. This however has removed their ability to format (add notes and colour cells) which is quite important to these users.

    If anyone can help out it would be greatly appreciated!

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    You can unlock cells without formulas. Unlocked cells can be used to input information.

    Select the cells you want, go to "Format", "Cells", uncheck the "locked option" and then protect the sheet.

    In your protection settings you can also allow for users to "format cells" (this allows for colour change) and not allow to insert rows or columns.
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

+ 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