"Jaws125" wrote:

We pick up some Excel files created on a Mac in 2002. When the files are
opened in any version of Windows or Excel small autoshape lines appear on the
left hand side. The lines can total up into the thousands and really slow
Excel down as well as show up when printed. We can not delete or group them.


The code was not correct but, it did provide a guide to help us find the
correct code. they were seen as autoshapes not lines. Thanks for the help and
here is the code that worked.

Sub DeleteAllLines()

ActiveSheet.Shapes.SelectAll
Selection.Delete

End Sub