Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2007

Tip: Looking for answers? Try searching our database.

Removing Passwords

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Claudia - 06 Sep 2007 22:54 GMT
Hi,
I currently work with Excel 2003. There is a worksheet that has a password
which I did not create. Yesterday it was fine but today when I try to type in
the cells i get a message that it is protected or read only. I already tried
the tools and properties menus to check if I can delete the read only or
password but have no luck? Does anyone know how to Remove a password that I
did not create nor anyone else? I am not sure how that can happen.
Thanks
CR
Gord Dibben - 06 Sep 2007 23:50 GMT
Worksheet passwords are entered in Tools>Protection>Protect Sheet.

You should be able to copy the cells from the worksheet to a new worksheet then
delete the offender.

If you want to crack the worksheet password see J.E. McGimpsey's site.

http://www.mcgimpsey.com/excel/removepwords.html

Gord Dibben  MS Excel MVP

>Hi,
>I currently work with Excel 2003. There is a worksheet that has a password
[quoted text clipped - 5 lines]
>Thanks
>CR
Claudia - 07 Sep 2007 00:56 GMT
Thank you! That's what I ended up doing. I just copied the entire sheet to
another worksheet. Question though.. can I save it under the same name &
pathe and my formulas wont change? I saved it under another name, but are
afraid to save it under the same name and lose something?
Thanks

> Worksheet passwords are entered in Tools>Protection>Protect Sheet.
>
[quoted text clipped - 16 lines]
> >Thanks
> >CR
Jim - 07 Sep 2007 06:13 GMT
Claudia,

if you try to save it in the same location and the same name, the system
should warn you that the file already exists, and ask you if you want to
replace it. As long as you're satisfied that the copied file is behaving as
you want, and has all the data you want, you could safely say yes. But you
may want to hang onto that original just in case there's something missing.
If the original name is important, you could rename the original file that
became protected, and then save your newly copied file as the original
filename.

Jim

> Thank you! That's what I ended up doing. I just copied the entire sheet to
> another worksheet. Question though.. can I save it under the same name &
[quoted text clipped - 31 lines]
>> >Thanks
>> >CR
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.