How to make a worksheet unchangeable by other users

  • Thread starter Thread starter wolfie
  • Start date Start date
W

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
 
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
 
You must log in or register to reply here.

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

Similar Threads

How to make cells collor unchange if data source change in format 2
Freeze Formulas - Replace Worksheet 5
worksheet renames - specific 0
PROTECTION FOR DIFFERENT COLUMN OF A WORKSHEET 1
Excel Disallow movement of embedded PDF 2
Link question 1
Cannot copy worksheet to another file 2
Unprotecting worksheets 2

Back
Top