Sharing and Protection

Mar 3rd, 2002, 06:10 AM

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 · Mar 4th, 2002, 03:35 AM

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

Mar 4th, 2002, 08:26 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 3rd, 2002, 06:10 AM	#1
Guest Posts: n/a	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

Mar 4th, 2002, 03:35 AM	#2
y2k Board Regular Join Date: Feb 2002 Location: Ireland Posts: 133	How about an auto_close macro that puts protection on and saves the workbook before it closes?

Mar 4th, 2002, 08:26 AM	#3
Guest Posts: n/a	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