Dear Mr Roy,

I encountered the similar problem as the link stated below:
http://www.excelforum.com/excel-prog...ml#post2529866.

I am unable to access when my workbook is shared, runtime error message " unprotect method sheet class failed" appear. My requirement is like what sivdin stated in the thread "multiple users should use the form and they should not have the access to edit the entries made by them"

Please offer me a solution for my problem.

Thank you.