Sharing a Workbook Error

[Sashi]

Sheet1:

It contains a form and a button "Save" where users can input information
(data validation present on some cells).

Sheet2:

Whenever the "Save" button is clicked from Sheet1, it automatically
populates a row in Sheet2. Both sheets protected. My code is actually
working perfectly fine-

The Problem:

It's just that- ideally this form SHOULD BE SHARED, but whenever I try to do
that, I get the error message "Run-time error '1004': Method 'Unprotect' of
object'_Workbook' failed"

Is there a way to remedy this error? What needs to be done?

Please help.

 

[Smitty]

Unfortunately programmatic Protection/Unprotection in shared wb's isn't
supported.

(At least up to v.2007, which I'm not sure about).

Smitty