Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking formats of cell
I think the solution to the should be fairly simple....but I've been playing
around with the protection settings and can't figure it out. Here's my situation... I have and excel sheet that I only want about 5 users out of about 50 to be able to make changes to it. Really all these users need to do is be able to select some cells and change the fill color. BUT the rest of the user should only be able to view the entire document. I was trying to protect worksheet and put passwords on it etc but nothing seems to work how I want it to. The one option of putting opening it as read only unless they have a password, still allows the users to "save-as" which defeats my purpose of not letting people make changes. Does anyone have suggestions..... I'm using 2003. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking formats of cell
Hello, Try, Tools=Options==security=password to modify |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking formats of cell
I tried that and it works. But is there some way I can stop users from being
able to 'save as'. Don't know if this is possible. Thanks "D." wrote: Hello, Try, Tools=Options==security=password to modify |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking Cell | Excel Worksheet Functions | |||
Locking cell | Excel Discussion (Misc queries) | |||
locking only one cell | Excel Discussion (Misc queries) | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Locking a cell | Excel Worksheet Functions |