Protecting a workbook

[Ken Loomis]

I need to give 4 people access to a workbook that resids on a network drive,
but only one will be allowed to make updates and changes.

Since it is a small group and everyone is a "trusted" user, I do not need to
protect the file from intentional modifications, just accidental
modifications.

I plan to provide two workbooks. One with just the code to view the workbook
and the other with an interface for adding and modifying the contents of the
workbook.

I thought I'd just protect the sheets in the workbook and have the "super"
user's workbook unprotect the sheets as needed to make modifications.

Is there another more efficient way or is there something else I should be
considering before trying to do it this way?

Thanks for any suggestions.

Ken Loomis

 

[Dave Peterson]

It might be easier to implement if you used the options under

File|SaveAs|Tools|General Options (xl2002+ wording)
File|SaveAs|Options (in earlier versions)

You can assign a password to open the workbook to modify. If the user doesn't
know the password, then they can open it readonly (or not open it at all).

Be aware that this won't stop them from making changes, saving as a new name
(and even overwriting your original workbook).

But you've got that problem with anything you do.

You will have to share the password with your "really trusted" coworkers.