Take a look at :

Features that are unavailable In Shared Workbooks

In the Excel Help.

Unprotecting a sheet can not be achieved in a shared workbook.

On Sep 15, 12:52*pm, soletyvenky
wrote:
I am using Office 2007.

I had done a VB project in Ms-Excel. I done all my coding using the normal
Protect Sheet option.

In between the program the code will Unprotect and protect the sheet.

Now this sheet has to be saved in Shared Workbook. So, that all the users
can update online at a time and put it on shared folder.

When i saved it. The unprotect and protect commands / code are not working
in Share Workbook.

Please solve the problem.

Regards,

Venkatesh Solety