Jump to content
groovyPost Forums

Excel- I have a workbook, that I want to protect

Guest fordman03

Recommended Posts

Guest fordman03

I have a workbook, that I would like to protect with a password, with these stipulations. I want people to be able to open the workbook with out a password and change things w/o a password, but I want it to require a password when saving, how can I do this?

Link to comment
Share on other sites

I assume your using Excel 2007?


If yes, just follow the steps mrgroove posted here:


Configure Password to Open or Password to Modify on Excel Spreadsheet


Although the demo shows word screenshots, the same is true for Excel. Basically what you want to do is set a MODIFY password.


This will allow users to open your excel spreadsheet with no password and make changes however they will need to save the changes to a NEW document unless they know the MODIFY password.


This is a good trick for creating a template. That's what I do at work.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Who's Online   0 Members, 0 Anonymous, 0 Guests (See full list)

    • There are no registered users currently online
  • Create New...