Sharing and Protection

[Guest]

My worksheets need to be protected (UserInterfaceOnly). When I save the workbook (for shared use) and re-open it .... I have to protect again with UserInterfaceOnly = true ... but protection with password is not allowed in shared use!
Is there any way to keep the userinterface of my worksheets protected and make it available for shared-use?
(I also need it to set AutoFilter On).

Thanks in advance,
Ton

 

[y2k]

How about an auto_close macro that puts protection on and saves the workbook before it closes?

 

[Guest]

That doesn't work.
When opening the worksheet, it's NOT protected with UserInterfaceOnly. I still have to re-protect the worksheets for this UserInterfaceOnly and that is not allowed in shared mode!
I get the impression that I want to do something that is really impossible!!??
Or ... does somebody know a solution for (a part of) the problem?
Ton