Password Protect-- Read Only Copy

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi,

We have a few excel files that several people use at the
same time. Is there any way to make sure that only one
designated person can open the orginal copies and the
others forced to use a Read Only Copy? Besides relying on
humans to close out if they open the original copy etc. :)

Thanks,
Ben
 
Ben,

The second and subsequent users who open the workbook should be in Read-Only
automatically, unless you've shared the workbook (Tools - Share workbook).
You might need to get with the network people about this.
 
Earl,

Thank you for the Tools - Share workbook)tip. That helps
immensley!

ben
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top