How to make a worksheet unchangeable by other users
 

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

How to make a worksheet unchangeable by other users
 

Password protect the sheet's contents
--
Gary''s Student - gsnu200787

How to make a worksheet unchangeable by other users
 

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

How to make a worksheet unchangeable by other users
 

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

"wolfie" wrote:

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