Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Share worksheet for certain people
How do I set protection for a worksheet, such that only allow certain people
have access or change/edit the worksheet on the network. Other people/group view it as read-only (NOT allow to change anything). Your help is greatly appreciated. Thanks |
#2
|
|||
|
|||
Go to Tools on the Menu and select Protection, protect sheet. If you're on XL
2003 you will be able to protect some of all elements. Remember to put in a password. "bioyyy" wrote: How do I set protection for a worksheet, such that only allow certain people have access or change/edit the worksheet on the network. Other people/group view it as read-only (NOT allow to change anything). Your help is greatly appreciated. Thanks |
#3
|
|||
|
|||
You can do that it network level. Right click on the file on the network and
goto security. There you can add people and select their different rights. With the user Everyone (you select the view option) and with those who are allowed to add it, you add as a single user with the different types of rights. -- ** Fool on the hill ** "bioyyy" wrote: How do I set protection for a worksheet, such that only allow certain people have access or change/edit the worksheet on the network. Other people/group view it as read-only (NOT allow to change anything). Your help is greatly appreciated. Thanks |
#4
|
|||
|
|||
Remember that Excel security is extremely weak, even with long complex passwords. Underneath those long passwords, Excel dummies up
the encryption making it child's play for very simple, widely available programs to hack. That goes for everything from opening the file itself to all internal spreadsheet passwords. I have such a PW hacking program for Excel, and I've never seen a file take more than about half of a second. -- RMC,CPA "bioyyy" wrote in message ... How do I set protection for a worksheet, such that only allow certain people have access or change/edit the worksheet on the network. Other people/group view it as read-only (NOT allow to change anything). Your help is greatly appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
macro to copy and edit then delete a worksheet | Excel Discussion (Misc queries) | |||
Worksheet Function - Find? | Excel Worksheet Functions | |||
grand total column B from every worksheet in workbook | Excel Discussion (Misc queries) | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |