Can Not Unprotect Workbook

[Evagrius Ponticus]

Hi all,

I have a workbook with a large amount of code. It has been working fine for several months. I opened it today and I was greeted with a vba error of "method unprotect object worksheet failed."

I of course tried to unlock the worksheet but the "unprotect sheet" function is grayed out! I went in the vbe and I get "project is unviewable". Can anyone advise?

 

[Smitty]

Did it somehow get Shared?

 

[Glory]

i wish I could tell you what was wrong. That sounds really frustrating.

I was encounter a "Catastrophic failure" message a couple nights ago that required me to recreate my entire workbook (userforms and all), copy and paste the code back into new modules and save over the old version. Some kind of corruption issue. Hopefully yours doesn't turn out that way, but just be aware that as long as you've got the code stored somewhere that should at least be an option. Just copy any sheets you want from the old workbook and recreate all the modules in an entirely new workbook.

 

[Evagrius Ponticus]

Wow Smitty - I owe you a chilled beverage of your choice. That's exactly what happened. Smitty, is there some way I can prevent this in VBA?

Thanks for the sympathy Glory - that has actually happened to me before. I was playing around with the "signature" feature of Excel and destroyed the workbook!

 

[Smitty]

No problem. Here's a link to an old post on programmatic sharing. I suppose you could test for the current share state when the wb opens and if it's shared remove it from shared status.