Hi,
I'd like to share a workbook made of 3 sheets.
However, I'd like to protect one of the sheets as its content is made
up via macros with the data from the first two sheets.
Unfortunately, the macro will return an error message:

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

The macro begins with the following code:
Sheets("Database").Select
ActiveSheet.Unprotect

If I don't share the workbook, the macro works fine.

Is it possible for the macro to unprotect the workbook in order to
perform the data handling?