| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excell automatically protecting a ws
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excell automatically protecting a ws
I dont understand what the problem is unless the attribute for the sheet was set to read only! -- 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...ad.php?t=43059 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excell automatically protecting a ws
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 "Simon Lloyd" wrote: I dont understand what the problem is unless the attribute for the sheet was set to read only! -- 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...ad.php?t=43059 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excell automatically protecting a ws
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) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=43059 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excell automatically protecting a ws
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 "Simon Lloyd" wrote: 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) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=43059 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excell automatically protecting a ws
You may even have to reset your Excel using the .xlb file!Alan;156108 Wrote: 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 "Simon Lloyd" wrote: 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' ('The Code Cage' (http://www.thecodecage.com)) ------------------------------------------------------------------------ Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1) View this thread: 'excell automatically protecting a ws - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=43059) -- 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...ad.php?t=43059 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing 2 workbooks automatically in Excell | Excel Worksheet Functions | |||
| Is there a way to automatically add sequential dates in excell? | New Users to Excel | |||
| Excell-Protecting sheet formatting | Excel Worksheet Functions | |||
| How do I advance the range by one row Excell VBA automatically | Excel Discussion (Misc queries) | |||
| How do I advance the range by one row Excell VBA automatically | Excel Discussion (Misc queries) | |||
Linear Mode
