+ Reply to Thread
Results 1 to 2 of 2

Password excel for admin (to modify), password for only reading

  1. #1
    Forum Contributor
    Join Date
    12-20-2014
    Location
    england
    MS-Off Ver
    2007
    Posts
    104

    Password excel for admin (to modify), password for only reading

    i have a fille in excel but i want to modify only me (with password) , other users only read only but with password it is posible?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,777

    Re: Password excel for admin (to modify), password for only reading

    Yes, but I'm not sure it was implemented in 2007. See this article to see how to save a workbook with one password required to open, another required to modify. The article only mentions 2010 and 2013.

    https://support.office.com/en-in/art...a-1931257c1517

    If this doesn't work for you, then you could save the workbook with one password required to open, then protect all worksheets and require another password to unprotect them for modification.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 11-17-2014, 04:28 PM
  2. VBA Ignore Password Prompts when reading in excel files
    By DaveNUFC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2011, 12:59 PM
  3. Admin Password for multiple workbooks
    By richard pabey in forum Excel General
    Replies: 1
    Last Post: 08-08-2006, 11:35 AM
  4. Replies: 0
    Last Post: 04-26-2006, 10:25 PM
  5. Replies: 0
    Last Post: 09-06-2005, 10:05 AM

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