View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Simon Lloyd[_288_] Simon Lloyd[_288_] is offline
external usenet poster
 
Posts: 1
Default unable to open protected document I created


TBryan;397914 Wrote:
I created a document with formulas and made it PW protected. I am now
precluded to open the document to make edits. I am unable to select
"unprotect" and use PW to make edits. I don't know how this can happen
on a
document I authored and have ownership. I need this document
desperately.

If the protection is greyed out it will normally be because either the
workbook is shared, in which case unshare it and all will be well, or
the code is in break mode, stop debugger and you should then be able to
enter your password....other than that i don't see how it could happen.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111100