Can't UNSHARE a shared workbook

[froggiebeckie]

Hi, all.
We have a workbook that has mysteriously become "Shared". (Of course, that old PITA Mr. Nobody is responsible for it.) and now I can't remove the protection in order to make corrections.

I've tried the normal:
Tools
Shareworkbook
Uncheck the Allow Changes by more.......

It doesn't work, and I can't figure out what to do next.

Any suggestions on how I can get this thing to where I can unprotect it?

Thanks in advance,

BeckieO

 

[Tana Lee]

Aloha...

Does this have any useful info for you?

http://www.mrexcel.com/board2/viewtopic.php?t=70502&highlight=unshare+workbook

Tana-Lee

 

[Mudface]

Tools-Protection- Unprotect and Share Workbook (?)

 

[froggiebeckie]

SUCCESS!!! Thanks all.
It seems the key is in the sequence:
First:
Tools
Protection
Unprotect and Share Workbook

THEN:
Tool
Share Workbook
Uncheck the Allow Changes by more.....


Thanks again, yall are great

BeckieO