Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default unable to open protected document I created

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,231
Default unable to open protected document I created

TBryan 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.


You mean you gave this file a File-Open password? If so, and you
forgot the password, there's very little you can do other than try to
guess the password or pay a service to try to figure out the password.
If you think you remember the password, the first thing to try is
reversing the capitalization you think you used in case Caps Lock was
on when you entered the password.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unable to open excel attachment, download won't open N. Joel Salzburg New Users to Excel 2 October 28th 08 01:21 PM
Can't open Excel 07 document I just created marteetwo Excel Discussion (Misc queries) 0 August 17th 07 02:07 AM
EXCEL 97 - Unable to open linked worksheets created in 2003 Van Excel Discussion (Misc queries) 0 January 5th 06 12:25 PM
Unable to open excel document across a network. John Excel Discussion (Misc queries) 1 September 30th 05 09:12 PM
Unable to open excel sheet in Protected mode from VB 6.0 ourspt Setting up and Configuration of Excel 0 January 26th 05 11:07 AM


All times are GMT +1. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"