I went into a workbook that I had (Protect and share workbook) protected to
do some modifications, when I selected unprotect workbook it didnt ask for
my password and seemed to unlock the book for editing. But this was not the
case; it stayed as a shared protected document. Why does this happen and how
do I fix it?
I also had each sheet protected and the whole workbook protected before
sharing the file, I have no access to undo this either.