Protecting A Shared Workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Melissa in New Orleans - 10 Oct 2006 19:37 GMT

Hi
I would like to share a workbook, allowing input by some, but
I would like some only to view the information
How can I accomplish this
MS Excel 2003

Signature

Thank you so much
Melissa in New Orleans

Reply to this Message

Dave Peterson - 10 Oct 2006 23:21 GMT

Protect the workbook with a "password to modify".

File|SaveAs|Tools|General options|provide a password to modify.

And only share that password with the people who should update the workbook.
The others will be able to open the file in readonly mode.

> Hi
> I would like to share a workbook, allowing input by some, but
[quoted text clipped - 4 lines]
> Thank you so much
> Melissa in New Orleans

Signature

Dave Peterson

Reply to this Message