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.

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

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.

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.

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.