cell format changing when when using search and replace.

's Computer Specifications

I have a macro that places a large number of pictures on a spreadsheet. I would like the pictures to show as "placeholders" to speed up viewing/editing. The only problem is that this feature (under Tools/Options/View) does not work. All the images are being display normally. I have tried this in Excel 2000/2003/XP with the same result. This feature works great in MS Word. Please help.

To see what I'm talking about. Go to Tools/Options/View and check the "Show Placeholders" option. Now insert a picture or clipart. The image will be displayed normally instead of just a blank box. Am I missing something?

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
cell format changing when when using search and replace.		Microsoft Excel Discussion	0	6th Jan 2006 02:42 AM
cell format changing when when using search and replace.		Microsoft Excel Misc	0	6th Jan 2006 02:41 AM
cell format changing when when using search and replace.		Microsoft Excel Misc	0	6th Jan 2006 02:41 AM
RE: cell format changing when when using search and replace.	=?Utf-8?B?Q2hhcmxpZQ==?=	Microsoft Excel Programming	1	13th Dec 2005 02:46 PM
cell format changing when when using search and replace.		Microsoft Excel Programming	0	13th Dec 2005 03:33 AM