share workbook issue

[oliverliu2]

Dears,

I wrote a VBA program which is protected by password and share the workbook. Unfortunately, I got an error when I execute my VBA.

"Run-time error '1004'
Unprotect method of Worksheet class failed"

Please Login or Register  to view this content.

Oliver

[Marc L]

Hi,

as here it's very not a mind readers forum so we can't guess which codeline raises the error ! Read the top screen yellow banner …

Try to unprotect during the execution, who knows …

[alansidman]

Try changing this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

or possibly name the sheet as in

Please Login or Register  to view this content.

[oliverliu2]

Dear Alan,

I tried your suggestion, but the problem still exists. One thing I need to mention is that the workbook is not only password protected, but also have several cells for editing.


Oliver