View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Unprotect shared worksheet

Hi All,

I created a protected worksheet in a shared workbook in order to allow the
users accessing only certain cells, but in macros I should like to change
some locked cells. Unfortunately XL2000 doesn't allow UnProtect method in a
shared workbook.
What can I do to fulfil both requirements (sharing and unprotecting)
simultaneously?

Thanks,
Stefi