Sorry for the delayed response. Thanks DP for your help.
I tried your solution and it is freezing my excel too.
2015-07-29 23:15 GMT+05:30 De Premor :
> Hi Vijayendra,
>
> I've look at your workbook, there is to many shapes "textbox" on your
> sheets, on sheet "a" there is 27.456 shapes, and on s
Hi Vijayendra,
I've look at your workbook, there is to many shapes "textbox" on your
sheets, on sheet "a" there is 27.456 shapes, and on sheet "b" 37.419 shapes.
You can use this code to know how many shape on it.
Dim i As Long
For i = 1 To Sheets.Count
MsgBox "Sheet " & Sheets(i).Name & v