Worksheet protection ...
Hi all,
I have inherited a worksheet from a colleague and when attempting to add data to certain cells I get a "These cells are protected" dialog box with the message "This information is inserted automatically". This is only in certain cells, others are OK. Whatever my colleague did, it was by accident, and therefore she doesn't remember. There is no "unprotect" option for these cells, or the worksheet in general. Can someone help me to remove this "supposed" protection? I am using Excel 2003. Thanks in advance. |
Worksheet protection ...
It may be the message from Data|validation.
Sharon R. wrote: Hi all, I have inherited a worksheet from a colleague and when attempting to add data to certain cells I get a "These cells are protected" dialog box with the message "This information is inserted automatically". This is only in certain cells, others are OK. Whatever my colleague did, it was by accident, and therefore she doesn't remember. There is no "unprotect" option for these cells, or the worksheet in general. Can someone help me to remove this "supposed" protection? I am using Excel 2003. Thanks in advance. -- Dave Peterson |
Worksheet protection ...
Maybe.........
Data Validation ClearAll ok Vaya con Dios, Chuck, CABGx3 "Sharon R." wrote: Hi all, I have inherited a worksheet from a colleague and when attempting to add data to certain cells I get a "These cells are protected" dialog box with the message "This information is inserted automatically". This is only in certain cells, others are OK. Whatever my colleague did, it was by accident, and therefore she doesn't remember. There is no "unprotect" option for these cells, or the worksheet in general. Can someone help me to remove this "supposed" protection? I am using Excel 2003. Thanks in advance. |
Worksheet protection ...
THANK YOU THANK YOU THANK YOU !! Didn't work first time round but I hadn't
selected all. So, you have saved my life (well, at least my sanity!). Thanks also to Dave Peterson who suggested the same solution. Sharon R. "CLR" wrote: Maybe......... Data Validation ClearAll ok Vaya con Dios, Chuck, CABGx3 "Sharon R." wrote: Hi all, I have inherited a worksheet from a colleague and when attempting to add data to certain cells I get a "These cells are protected" dialog box with the message "This information is inserted automatically". This is only in certain cells, others are OK. Whatever my colleague did, it was by accident, and therefore she doesn't remember. There is no "unprotect" option for these cells, or the worksheet in general. Can someone help me to remove this "supposed" protection? I am using Excel 2003. Thanks in advance. |
Worksheet protection ...
Happy you're sane <g.........and thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "Sharon R." wrote: THANK YOU THANK YOU THANK YOU !! Didn't work first time round but I hadn't selected all. So, you have saved my life (well, at least my sanity!). Thanks also to Dave Peterson who suggested the same solution. Sharon R. "CLR" wrote: Maybe......... Data Validation ClearAll ok Vaya con Dios, Chuck, CABGx3 "Sharon R." wrote: Hi all, I have inherited a worksheet from a colleague and when attempting to add data to certain cells I get a "These cells are protected" dialog box with the message "This information is inserted automatically". This is only in certain cells, others are OK. Whatever my colleague did, it was by accident, and therefore she doesn't remember. There is no "unprotect" option for these cells, or the worksheet in general. Can someone help me to remove this "supposed" protection? I am using Excel 2003. Thanks in advance. |
All times are GMT +1. The time now is 07:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com