ProtectSharing
 

Would like to get a conversation started with anyone who
has a really good handle on the
ThisWorkbook.ProtectSharing feature. Ideally I want to be
able to set it from Access VBA, but failing that I want to
set it via an Excel procedure, and I'm getting some quirky
results. ProtectSharing Guru, show thyself!