ExcelBanter - HOW DO I DELETE SHAPES THAT ARE IN SPREADSHEETS?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HOW DO I DELETE SHAPES THAT ARE IN SPREADSHEETS? (https://www.excelbanter.com/excel-discussion-misc-queries/72429-how-do-i-delete-shapes-spreadsheets.html)

Chuck

HOW DO I DELETE SHAPES THAT ARE IN SPREADSHEETS?

I have tried highlighting the objects/autoshapes and selecting delete but
they will not go away. Is there a setting that would cause objects to be
unable to be deleted. Thanks,

Don Guillett

HOW DO I DELETE SHAPES THAT ARE IN SPREADSHEETS?

try CUT instead of delete

--
Don Guillett
SalesAid Software

"Chuck" wrote in message
...
I have tried highlighting the objects/autoshapes and selecting delete but
they will not go away. Is there a setting that would cause objects to be
unable to be deleted. Thanks,

Ron de Bruin

HOW DO I DELETE SHAPES THAT ARE IN SPREADSHEETS?

Hi v

Have you try F5Special..Objects
And press the delete button

Or with code
http://www.rondebruin.nl/controlsobjectsworksheet.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Chuck" wrote in message ...
I have tried highlighting the objects/autoshapes and selecting delete but
they will not go away. Is there a setting that would cause objects to be
unable to be deleted. Thanks,

All times are GMT +1. The time now is 12:41 PM.