I have a problem with programming images.

I'm creating a file where I have to add about 50 images. These images must
be visible or not depending on some criteria. I would like to know if its
possible to write a code that could make hide or unhide images inserted via:
insert/pictures/from file.

I know I could work with pictures inserted via visual basic tool bar, but
the problem is the memory it needs.

Can you help me, please?

Thanks to all!
Sorry for my poor English...
--
atrep

Pictures have a visible property that can hide or unhide images. Hiding an
imagge will not change the amount of memory it uses. You may want to reduce
the image resolution to reduce the amount of memory it uses.

what I do to reduce the imagge size iis to email the file to myself. It you
go to the Window explorer and right click the image. Then select SEND TO
and sleect Mail resipient a popup will appear that asks if you want to make
the image smaller. click Yes. This reduces most images to 50K to 70K.

"xavi garriga" wrote:

I have a problem with programming images.

I'm creating a file where I have to add about 50 images. These images must
be visible or not depending on some criteria. I would like to know if its
possible to write a code that could make hide or unhide images inserted via:
insert/pictures/from file.

I know I could work with pictures inserted via visual basic tool bar, but
the problem is the memory it needs.

Can you help me, please?

Thanks to all!
Sorry for my poor English...
--
atrep

I'm sorry Joel, I've inserted the same image (.gif) following the two ways
and this is the result:

a)Insert/picture/from file and the memory used is 31 KB
b) Inserting a picture with VB tool bar. Memory used: 121KB

I it posible to modify properties following the first way?

Thanks to all!
--
atrep


"Joel" wrote:

Pictures have a visible property that can hide or unhide images. Hiding an
imagge will not change the amount of memory it uses. You may want to reduce
the image resolution to reduce the amount of memory it uses.

what I do to reduce the imagge size iis to email the file to myself. It you
go to the Window explorer and right click the image. Then select SEND TO
and sleect Mail resipient a popup will appear that asks if you want to make
the image smaller. click Yes. This reduces most images to 50K to 70K.

"xavi garriga" wrote:

I have a problem with programming images.

I'm creating a file where I have to add about 50 images. These images must
be visible or not depending on some criteria. I would like to know if its
possible to write a code that could make hide or unhide images inserted via:
insert/pictures/from file.

I know I could work with pictures inserted via visual basic tool bar, but
the problem is the memory it needs.

Can you help me, please?

Thanks to all!
Sorry for my poor English...
--
atrep

You can compress a picture by right click and the select format picture. On
the picture tab there is a compress button.

"xavi garriga" wrote:

I'm sorry Joel, I've inserted the same image (.gif) following the two ways
and this is the result:

a)Insert/picture/from file and the memory used is 31 KB
b) Inserting a picture with VB tool bar. Memory used: 121KB

I it posible to modify properties following the first way?

Thanks to all!
--
atrep


"Joel" wrote:

Pictures have a visible property that can hide or unhide images. Hiding an
imagge will not change the amount of memory it uses. You may want to reduce
the image resolution to reduce the amount of memory it uses.

what I do to reduce the imagge size iis to email the file to myself. It you
go to the Window explorer and right click the image. Then select SEND TO
and sleect Mail resipient a popup will appear that asks if you want to make
the image smaller. click Yes. This reduces most images to 50K to 70K.

"xavi garriga" wrote:

I have a problem with programming images.

I'm creating a file where I have to add about 50 images. These images must
be visible or not depending on some criteria. I would like to know if its
possible to write a code that could make hide or unhide images inserted via:
insert/pictures/from file.

I know I could work with pictures inserted via visual basic tool bar, but
the problem is the memory it needs.

Can you help me, please?

Thanks to all!
Sorry for my poor English...
--
atrep

I haven't found this option, maybe because of my excel version, 2000.

I will try to work in another way... I have inserted an image via
Insert/image/ from file... and recorded a Macro, the Macro treats the image
like a "shape" I think I will try to continue working this way, do you think
it's correct?

Thanks for all!
--
atrep


"Joel" wrote:

You can compress a picture by right click and the select format picture. On
the picture tab there is a compress button.

"xavi garriga" wrote:

I'm sorry Joel, I've inserted the same image (.gif) following the two ways
and this is the result:

a)Insert/picture/from file and the memory used is 31 KB
b) Inserting a picture with VB tool bar. Memory used: 121KB

I it posible to modify properties following the first way?

Thanks to all!
--
atrep


"Joel" wrote:

Pictures have a visible property that can hide or unhide images. Hiding an
imagge will not change the amount of memory it uses. You may want to reduce
the image resolution to reduce the amount of memory it uses.

what I do to reduce the imagge size iis to email the file to myself. It you
go to the Window explorer and right click the image. Then select SEND TO
and sleect Mail resipient a popup will appear that asks if you want to make
the image smaller. click Yes. This reduces most images to 50K to 70K.

"xavi garriga" wrote:

I have a problem with programming images.

I'm creating a file where I have to add about 50 images. These images must
be visible or not depending on some criteria. I would like to know if its
possible to write a code that could make hide or unhide images inserted via:
insert/pictures/from file.

I know I could work with pictures inserted via visual basic tool bar, but
the problem is the memory it needs.

Can you help me, please?

Thanks to all!
Sorry for my poor English...
--
atrep

You may need to go into Design Mode to get the properties.

ON worksheet menu View - toolbars - Control Toolbox. then select the
triangle to enter and exit Design mode. when you are in design mode right
click object to get properties. Also on the tool bar is a property icon.

"xavi garriga" wrote:

I haven't found this option, maybe because of my excel version, 2000.

I will try to work in another way... I have inserted an image via
Insert/image/ from file... and recorded a Macro, the Macro treats the image
like a "shape" I think I will try to continue working this way, do you think
it's correct?

Thanks for all!
--
atrep


"Joel" wrote:

You can compress a picture by right click and the select format picture. On
the picture tab there is a compress button.

"xavi garriga" wrote:

I'm sorry Joel, I've inserted the same image (.gif) following the two ways
and this is the result:

a)Insert/picture/from file and the memory used is 31 KB
b) Inserting a picture with VB tool bar. Memory used: 121KB

I it posible to modify properties following the first way?

Thanks to all!
--
atrep


"Joel" wrote:

Pictures have a visible property that can hide or unhide images. Hiding an
imagge will not change the amount of memory it uses. You may want to reduce
the image resolution to reduce the amount of memory it uses.

what I do to reduce the imagge size iis to email the file to myself. It you
go to the Window explorer and right click the image. Then select SEND TO
and sleect Mail resipient a popup will appear that asks if you want to make
the image smaller. click Yes. This reduces most images to 50K to 70K.

"xavi garriga" wrote:

I have a problem with programming images.

I'm creating a file where I have to add about 50 images. These images must
be visible or not depending on some criteria. I would like to know if its
possible to write a code that could make hide or unhide images inserted via:
insert/pictures/from file.

I know I could work with pictures inserted via visual basic tool bar, but
the problem is the memory it needs.

Can you help me, please?

Thanks to all!
Sorry for my poor English...
--
atrep

Hi Joel!

I know I have to be in design mode. However, when I am in the design mode I
cannot change image properties(remember I've inserted the image by
"Insert/picture/from file"), when I click on the image, on the properties
window, appears the activesheet properties. I think it should be problem of
the version, I will try this evening at home and tomorrow morning (Spain)I
will tell you the results.

Thanks!
--
atrep


"Joel" wrote:

You may need to go into Design Mode to get the properties.

ON worksheet menu View - toolbars - Control Toolbox. then select the
triangle to enter and exit Design mode. when you are in design mode right
click object to get properties. Also on the tool bar is a property icon.

"xavi garriga" wrote:

I haven't found this option, maybe because of my excel version, 2000.

I will try to work in another way... I have inserted an image via
Insert/image/ from file... and recorded a Macro, the Macro treats the image
like a "shape" I think I will try to continue working this way, do you think
it's correct?

Thanks for all!
--
atrep


"Joel" wrote:

You can compress a picture by right click and the select format picture. On
the picture tab there is a compress button.

"xavi garriga" wrote:

I'm sorry Joel, I've inserted the same image (.gif) following the two ways
and this is the result:

a)Insert/picture/from file and the memory used is 31 KB
b) Inserting a picture with VB tool bar. Memory used: 121KB

I it posible to modify properties following the first way?

Thanks to all!
--
atrep


"Joel" wrote:

Pictures have a visible property that can hide or unhide images. Hiding an
imagge will not change the amount of memory it uses. You may want to reduce
the image resolution to reduce the amount of memory it uses.

what I do to reduce the imagge size iis to email the file to myself. It you
go to the Window explorer and right click the image. Then select SEND TO
and sleect Mail resipient a popup will appear that asks if you want to make
the image smaller. click Yes. This reduces most images to 50K to 70K.

"xavi garriga" wrote:

I have a problem with programming images.

I'm creating a file where I have to add about 50 images. These images must
be visible or not depending on some criteria. I would like to know if its
possible to write a code that could make hide or unhide images inserted via:
insert/pictures/from file.

I know I could work with pictures inserted via visual basic tool bar, but
the problem is the memory it needs.

Can you help me, please?

Thanks to all!
Sorry for my poor English...
--
atrep