I have a work book which automatically calculates the results in the protected
area based on the user input in the unprotect cells.

When the user inputs the data in the particular unproteced cell, the result will
be automatically fixed in the specified cell which is protected .

As more than three people are using the same file, I made that file as shared
and run the macro. Here I am getting an error message that workfile can't be
protect / unprotect in the Shared mode.

Could any one please help me how to resolve this issue?