Quickly change images in sheet

[Waxwing]

I have a model that contains about a dozen worksheets and charts.
Each sheet and chart contains an image of the company logo that when
clicked fires a sub process. In addition there is one user form that
includes this image.

We frequently give this model to clients and need to convert our logo
to their logo. I need a way to be able to quickly change from one
logo to the other without loosing the properties of each individual
image (size, hyperlink, macro, etc.)

I don't know enough about images to know where to start.

Thanks for the help.

- John

[kiat]

Image is a control which has the Picture property. This is what the help
says about Picture:

Specifies the bitmap to display on an object.

Syntax

object.Picture = LoadPicture( pathname )

The Picture property syntax has these parts:

Part Description
object Required. A valid object.
pathname Required. The full path to a picture file.

Remarks

While designing a form, you can use the control's property page to assign a
bitmap to the Picture property. While running a form, you must use the
LoadPicture function to assign a bitmap to Picture.

To remove a picture that is assigned to a control, click the value of the
Picture property in the property page and then press DELETE. Pressing
BACKSPACE will not remove the picture.

Note For controls with captions, use the PicturePosition property to
specify where to display the picture on the object. Use the PictureSizeMode
property to determine how the picture fills the object.

Transparent pictures sometimes have a hazy appearance. If you do not like
this appearance, display the picture on a control that supports opaque
images. Image and MultiPage support opaque images.

"Waxwing" <waxw...@hotmail.com> wrote in message
news:690bf32f.03060...@posting.google.com...