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 d...@premor.net: 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,

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 vbCrLf