Re: $$Excel-Macros$$ Excel workbook Issues

2015-08-25 Thread Vijayendra Rao
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

Re: $$Excel-Macros$$ Excel workbook Issues

2015-07-29 Thread 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 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