Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Worksheet protection vs filters
Im trying to protect my worksheet to stop other users from buggering it up
but when i protect it the filters dont work. Is there a way of making it work on excel 2000? I have tried to do it in a macro but when i run it the password box comes up and I manually have to put the password in so this doesnt work! any ideas? |
#2
|
|||
|
|||
With worksheets("Sheet1") .Protect UserInterFaceOnly:=True .enableAutoFilter End With -- Regards, Tom Ogilvy "Paul" wrote in message ... Im trying to protect my worksheet to stop other users from buggering it up but when i protect it the filters dont work. Is there a way of making it work on excel 2000? I have tried to do it in a macro but when i run it the password box comes up and I manually have to put the password in so this doesnt work! any ideas? |
#3
|
|||
|
|||
"Paul" wrote in message ... Im trying to protect my worksheet to stop other users from buggering it up but when i protect it the filters dont work. Is there a way of making it work on excel 2000? I have tried to do it in a macro but when i run it the password box comes up and I manually have to put the password in so this doesnt work! any ideas? You can protect and unprotect from VBA. Use something like ActiveWorkbook.Unprotect Password:="Bagheera" 'Your code here ActiveWorkbook.Protect Structu=True, Windows:=False, Password:="Bagheera" /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I protect an excel worksheet containing filters? | Excel Discussion (Misc queries) | |||
Worksheet Protection | Excel Worksheet Functions | |||
Prevent unhide of rows/columns w/out worksheet protection? | Excel Discussion (Misc queries) | |||
copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Seeking help for total worksheet protection | Excel Discussion (Misc queries) |