+ Reply to Thread
Results 1 to 4 of 4

Password protect or read only

  1. #1
    Registered User
    Join Date
    03-30-2012
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    2

    Password protect or read only

    I have an Excel 2010 spreadsheet that will be accessed by many users. I want it to be read-only, unless they put in a password, then they can edit. This must be able to be done, because I work with a spreadsheet that was created by someone else that when you open it, a little box pops up asking for the password, which you can enter, or you can press read only.

    I don't want to do the "mark as final" option, because then they can't edit if they want. I also already know how to password protect my spreadsheet, but that doesn't give you the option to read only. I don't want people editing if they don't have the password.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Password protect or read only

    If you point your mouse to the worksheet (tab) and right click, there's an option called Protect Sheet. Is that what you're looking for?

  3. #3
    Registered User
    Join Date
    11-06-2011
    Location
    Massachusetts, USA
    MS-Off Ver
    Excel 2010
    Posts
    52

    Re: Password protect or read only

    If that isn't the solution, the OP may be looking for:

    On the Files tab; Save As, Tools, General Options, and passwords can be specified to open or modify.

  4. #4
    Registered User
    Join Date
    03-30-2012
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    2

    Thumbs up Re: Password protect or read only

    Yes!! Thank you!


    Quote Originally Posted by Canuck Chuck View Post
    If that isn't the solution, the OP may be looking for:

    On the Files tab; Save As, Tools, General Options, and passwords can be specified to open or modify.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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