Issue with Shape(text box)
I have macro in my workbook (Excel2003) which breaks formula links for text
boxes present in the workbook. The code used for the same is
"shp.DrawingObject.Formula = Empty"
This works perfectly fine in Excle 2003 but, when run in Excel 2007 all the
textboxes whose formula link is broken lose the formatting.
I tried to search for DrawingObject information, but couldn't find anything.
Any help appreciated.
Thanks in advance.
|