Autoshapes loose formating when formula is removed

Anand Nichkaode

Guest

Posts: n/a

21st Aug 2009

Hi,

I am facing a strange problem.

The Autoshapes from the workbook, Excel97-2003 or Excel 2007, loose the
formatting when their formula is removed. This happens when I remove the
formula either manually or throgh a macro.

Has anybody ever faced this issue? Does anybody know why this happening? Can
anybody tell me how to stop this happening?

Thanks in advance.

-Thx
Anand

« col A,B and C-P moved fr Sheet 1,2, to Sheet 4 | programming in vb.net application »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Loose formula/value (when building graphs)	PvZ	Microsoft Excel Worksheet Functions	3	2nd Jun 2010 12:24 PM
Loose formating of linked cells	jocoman@sympatico.ca	Microsoft Excel Programming	3	7th Dec 2007 10:24 AM
Paste HTML from a web page: either loose content, or loose format	=?Utf-8?B?QWxleCBKYXJyYW4=?=	Microsoft Outlook Calendar	0	22nd Apr 2006 03:44 AM
Tracked Changes Removed remove formating	eric.styles@gmail.com	Microsoft Word New Users	3	17th Nov 2005 10:36 PM
copy web pages into PP 2003 - loose formating	=?Utf-8?B?QWxhbg==?=	Microsoft Powerpoint	15	13th Mar 2005 02:22 AM