View Single Post
  #2   Report Post  
Romanian37
 
Posts: n/a
Default How do I lock an image in Excel so it doesn't move?


Two possible options that I can think of:

(i) in the Properties tab of the Format Picture option box (accessed by
right clicking when on image), click DOn't move or size with cells radio
button. This should lock the image size.
(ii) More complicated option is to set up the price list in Word and
have a macro take any price values from a corresponding excel master
sheet. You can probably then format the price list in a more intuitve
way in word but have the values easily changeable in excel. This would
be a fairly involbed solution though!

Cheers

Will


--
Romanian37
------------------------------------------------------------------------
Romanian37's Profile: http://www.excelforum.com/member.php...fo&userid=9759
View this thread: http://www.excelforum.com/showthread...hreadid=478248