Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workbook Security
I would like to password protect a worksheet for cell contents, but allow for
any other manipulation of the file using any of the other functions - except deleting. I tried suggesting read only - although I told the team members they do not need the password to use the file, they do not grasp the concept. Next I tried to protect the worksheet and allow filtering, inserting columns & rows, - everything but changing contents and deleting, but the menu functionally will not work. Example = auto filter. When protected one can not create the filter, it has to be put in place before protecting. Then when the filter is used, one can not choose to turn off the auto filter to get rid of multiple filters. Is there a VB script that will do what I want? If so, how do I apply it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook security | Excel Discussion (Misc queries) | |||
security of workbook | Excel Discussion (Misc queries) | |||
Excel Security for Shared Workbook | Excel Discussion (Misc queries) | |||
How do I identify who placed security on a workbook? | Excel Worksheet Functions | |||
sheet and workbook security | Excel Discussion (Misc queries) |