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

Archived

This topic is now archived and is closed to further replies.

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

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