How to remove text edit from Autoshapes

[SupperDuck]

Hello,

When we add an autoshape to excel and select "no fill" to colour, i can
reach the cell behind the autoshape so what i write in the autoshape is
written to the cell behind it. It is fine.

But, when i select the autoshape with right click and say "edit text" i can
not then change the cell behind it if i do not move the autoshape to another
place.

Is there any switch to turn "edit text" for the autoshapes?

thanks& Regards,

Veysel

 

[Don Guillett]

Think about it....

 

[Bob I]

Hello,

When we add an autoshape to excel and select "no fill" to colour, i can
reach the cell behind the autoshape so what i write in the autoshape is
written to the cell behind it. It is fine.

What you "write in the autoshape" is NOT written to the cell behind it.
You are actually writing in the cell. You have made the Autoshape
transparent, and there is nothing in it. Edit text writes in the autoshape.

But, when i select the autoshape with right click and say "edit text" i can
not then change the cell behind it if i do not move the autoshape to another
place.

Is there any switch to turn "edit text" for the autoshapes?

thanks& Regards,

Veysel

You will need to decide whether you wish the text in the Cell, or in the
Autoshape. That is all.

 

[SupperDuck]

Hello,

But just guess that it has been made by mistake and i need to turn "edit
text" option off. I need the autoshape not to be written any thing when i
press on it...

Regards

 

[Bob I]

Then you will have to Lock it and then Protect the sheet.