Hi,
Is it possible to have a macro which will blow a picture up when you click
on it, and then will shrink it again if clicked again, and will work on any
picture i.e. only one macro need be written?
Regards
John

Just thought of something that would probably be better.
Is it possible to click on the picture so that it would open in a new window
so that you can use the X to close again?
The workbook would have approx 200 pictures, so if at all possible have one
code that can pick up any picture
Help greatly appreciated. Many thanks
John


"JohnUK" wrote:

Hi,
Is it possible to have a macro which will blow a picture up when you click
on it, and then will shrink it again if clicked again, and will work on any
picture i.e. only one macro need be written?
Regards
John

You could use a Userform with a Image on it, and it would be populated by
the image selected.
However, i feel you would need the Image location(C:\Documents and
Settings\User\My Documents\My Pictures.Example.jpg) in a cell for this to
work.


Corey....
"JohnUK" wrote in message
...
Just thought of something that would probably be better.
Is it possible to click on the picture so that it would open in a new
window
so that you can use the X to close again?
The workbook would have approx 200 pictures, so if at all possible have
one
code that can pick up any picture
Help greatly appreciated. Many thanks
John


"JohnUK" wrote:

Hi,
Is it possible to have a macro which will blow a picture up when you
click
on it, and then will shrink it again if clicked again, and will work on
any
picture i.e. only one macro need be written?
Regards
John