Protected Shared Workbook
 

I created a user app/ spreadsheet .

I tested workbooks/worksheet and everything was fine then I made
a mistake and accidentially Protected it as a Shared Workbook.

Now the code is hanging up on what I'm guessing is a
ActiveSheet.Unprotect line
Is there anyway to reset the file so that its not shared? There's no
password on it.
But even when I Unprotect it, I can't access the VB modules anymore.

Protected Shared Workbook
 

Marston,

Goto tools|Share workbook and untick "Allow changes" click OK

Neil

" wrote in message
oups.com...
I created a user app/ spreadsheet .

I tested workbooks/worksheet and everything was fine then I made
a mistake and accidentially Protected it as a Shared Workbook.

Now the code is hanging up on what I'm guessing is a
ActiveSheet.Unprotect line
Is there anyway to reset the file so that its not shared? There's no
password on it.
But even when I Unprotect it, I can't access the VB modules anymore.