How to make a worksheet unchangeable by other users

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wolfie - 20 May 2008 11:19 GMT

I want to place an Excel sheet on a shared drive for others to see but I
don't want them to be able to alter or input any data

Reply to this Message

Gary''s Student - 20 May 2008 11:33 GMT

Password protect the sheet's contents

Signature

Gary''s Student - gsnu200787

Reply to this Message

Jan Karel Pieterse - 20 May 2008 11:38 GMT

Hi Wolfie,

> I want to place an Excel sheet on a shared drive for others to see but I
> don't want them to be able to alter or input any data

You can add a "password to modify" to a file. Do a file, save as and click the
Tools button, select "general options" and enter the "Password to modify"
there.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

Reply to this Message

san - 20 May 2008 12:05 GMT

If you are using office2007 then
Click on Review Tab -> Select protect & Share workbook -> Check on sharing
with Track changes checkbox-> provide the password->click Ok

If you are using office2003 then
From menu select Tools -> Protection -> Check on sharing with Track changes
checkbox->Select protect & Share workbook->provide the password->click Ok

> I want to place an Excel sheet on a shared drive for others to see but I
> don't want them to be able to alter or input any data

Reply to this Message