Can't unshare file because File is locked

**execaps** · 09-20-2012, 07:21 AM

Hi, everyone! I'm new to this forum and new also in using VBA. I've made a file with VBA to somewhat automatize our project drawing logbook. VBA related to static date stamping which I refer from topics of this forum. It seems that everything works right, therefore I went to the next level. I protected and shared the file to our network system and try if everything will still work. Almost ok but still requires further refinement.

Now comes the problem, I want to unshare it to edit the file but it's giving a notification that file is locked and also I can't unprotect. Is this due to VBA? Can someone please help me?

I attached the file for everybody's verification. Password is execaps

Thanks in advance.

**JosephP** · 09-20-2012, 07:31 AM

worked for me

**execaps** · 09-20-2012, 07:44 AM

Wow, that was fast! thanks JosephP. Any special spell? Can you please tell me so that I'll know the solution if it happens again. Been working for hours to recover that. Almost all icon was greyed-out a while ago.

Cheers!

**JosephP** · 09-20-2012, 07:51 AM

I just clicked the 'unprotect shared workbook' button :-)

**execaps** · 09-20-2012, 08:02 AM

Here's the error am having a while ago, and upto now... the file in our network can't be unprotected. Do u think it's a network problem and not the file? Anyway, thanks that my file is editable again!Drawing List Error.jpg