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