| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make a worksheet unchangeable by other users
Password protect the sheet's contents
-- Gary''s Student - gsnu200787 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make sure my Wkbook is accessible to users using earlier | Excel Discussion (Misc queries) | |||
| how to allow other users to make changes for some perticular cells | Setting up and Configuration of Excel | |||
| How to allow all users to make changes to unlocked cells on WrkSh | Excel Discussion (Misc queries) | |||
| How do I allow users to make a choice in a worksheet? | Excel Worksheet Functions | |||
| How can I allow other users to make changes in a shared workbook | Excel Discussion (Misc queries) | |||
Linear Mode
