excell automatically protecting a ws

A

Alan

Downloaded a ws and can't edit it due to protection, which requires a
password to remove the protection. Sender insists it's not protected.
Forwarded the ws to my work computer and all's fine. It was NOT protected
My version is Office 2000, works version is Office 2003.
All other ws on the computer are fine.
 
A

Alan

Thanks Simon for your quick response, However,the problem ws is not read
only, no matter which cell i try to type in it states that it's protected and
when I try to unprotect it, password is asked for.( I'm using Office
2000).The originator of the ws states that its not protected, hence no
password used. I then sent the ws to my wife's computer(which uses Office
2003) and she has no problems. To prove it, she entered a few cells and sent
it back to me.Once again my excell says it's protected and I can't use the
ws. I copied the ws onto a usb stick (directly from outlook express) and
transferred it to my laptop (which is also using Office 2000) and still can't
edit the ws. I received this ws the other day and it's the only ws I've had
this problem with. All other ws on both my computers behave perfectly
correct. I'm stumped
 
S

Simon Lloyd

I have 2000, 2003 ans 2007 and cannot replicate your problem, have you
tried opening PERSONAL.XLS and see if there are any macro's in it
specifically dealing with a sheet named the same as the one you are
trying to open?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
 
A

Alan

Will try what you suggest and let you know, may be after Christmas because
I'm off to UK for a couple of days. Thanks once again for your prompt reply.

Alan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting/Unprotecting all sheets with macro leads to "image" iss 3
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
including macro in protected worksheet 2
Problem in adding macro to ribbon through Add-in 7
Can't save my Office documents (after computer rebuild and reauthorization) 0
Hide Macro 3
Wood 2010 Form and submitting via email 5
Can't open passworded protected Mac Office 2011's Word .docx in Office2000 SP3 with converter packs? 0

Top