In order to unprotect a shared workbook you'll have to disable the share
option.
--
Kevin Backmann


"kgaber" wrote:

I have password protected a shared workbook. I need to make chages to the
formatting and I am unable to unprotect it. When I go to protection it does
not give me the option to unprotect. I know the password, but I cannot seem
to find where to enetr it to unlock