There is any way to make a hole in a picture and that hole should be exactly
on top of an Excel Cell?

You would have to create a transparent section in the image, and then
the image would have to be Locked to the sheet. YMMV.

Dan Tabla wrote:

There is any way to make a hole in a picture and that hole should be exactly
on top of an Excel Cell?

Excel 2007
Shape filled with pictu
http://www.mediafire.com/file/n1mgwnznot0/03_15_10.pdf

Cool idea. I think so. Excel can import .GIF images. GIF images support
transparency. Then it is a matter of designing the GIF so that it's size is
right and the cell size hole is right. Also, you would have a problem
"Clicking" in the cell afterwards because the image would be in front of it.
However, if all you do is use the cell the output values, then it should be
fine.



"Dan Tabla" wrote in message
...
There is any way to make a hole in a picture and that hole should be
exactly
on top of an Excel Cell?

First of all thank you all of you for answering to my ambigous question.

Originally, I have an application that requires to fill in 20 screens.
I had a good ideea to make print screens as long as I go along the
applications steps and set
up the Excel Workbook' backround with this print screens and I can type the
desired values on top of the
pictures simulating that I m using the original application (just to keep a
good track of work).
After I finalize this filling step I have a VBA procedure that is using
SendKeys function to send the desired
values to the original application. In the end I can save the excel workbook
so I wont
have to work all the steps out as long as they are very repetitive to a
certain point.

Tkx a lot for any help! This is a lovely community here!
"Dennis Tucker" wrote:

Cool idea. I think so. Excel can import .GIF images. GIF images support
transparency. Then it is a matter of designing the GIF so that it's size is
right and the cell size hole is right. Also, you would have a problem
"Clicking" in the cell afterwards because the image would be in front of it.
However, if all you do is use the cell the output values, then it should be
fine.



"Dan Tabla" wrote in message
...
There is any way to make a hole in a picture and that hole should be
exactly
on top of an Excel Cell?

.

Herbert this link is opening an example of a picture but is not explaining
anything.

"Herbert Seidenberg" wrote:

Excel 2007
Shape filled with pictu
http://www.mediafire.com/file/n1mgwnznot0/03_15_10.pdf

.

Can you go to FormatSheetBackground and choose your "print screen" image
as background?

It won't have "holes" in it but if light enough you can see the cells on top
of the BG and type in them.


Gord Dibben MS Excel MVP


On Mon, 15 Mar 2010 13:53:01 -0700, Dan Tabla
wrote:


First of all thank you all of you for answering to my ambigous question.

Originally, I have an application that requires to fill in 20 screens.
I had a good ideea to make print screens as long as I go along the
applications steps and set
up the Excel Workbook' backround with this print screens and I can type the
desired values on top of the
pictures simulating that I m using the original application (just to keep a
good track of work).
After I finalize this filling step I have a VBA procedure that is using
SendKeys function to send the desired
values to the original application. In the end I can save the excel workbook
so I wont
have to work all the steps out as long as they are very repetitive to a
certain point.

Tkx a lot for any help! This is a lovely community here!
"Dennis Tucker" wrote:

Cool idea. I think so. Excel can import .GIF images. GIF images support
transparency. Then it is a matter of designing the GIF so that it's size is
right and the cell size hole is right. Also, you would have a problem
"Clicking" in the cell afterwards because the image would be in front of it.
However, if all you do is use the cell the output values, then it should be
fine.



"Dan Tabla" wrote in message
...
There is any way to make a hole in a picture and that hole should be
exactly
on top of an Excel Cell?

.

Yes you can attach a Print Screen but problem still not solved because I have
to attach several Print Screens vertically and I dont know how to do it. In
the end I should have to attach a very long picture...Paint is limited, you
can put together only 2 print screens.

"Gord Dibben" wrote:

Can you go to FormatSheetBackground and choose your "print screen" image
as background?

It won't have "holes" in it but if light enough you can see the cells on top
of the BG and type in them.


Gord Dibben MS Excel MVP


On Mon, 15 Mar 2010 13:53:01 -0700, Dan Tabla
wrote:


First of all thank you all of you for answering to my ambigous question.

Originally, I have an application that requires to fill in 20 screens.
I had a good ideea to make print screens as long as I go along the
applications steps and set
up the Excel Workbook' backround with this print screens and I can type the
desired values on top of the
pictures simulating that I m using the original application (just to keep a
good track of work).
After I finalize this filling step I have a VBA procedure that is using
SendKeys function to send the desired
values to the original application. In the end I can save the excel workbook
so I wont
have to work all the steps out as long as they are very repetitive to a
certain point.

Tkx a lot for any help! This is a lovely community here!
"Dennis Tucker" wrote:

Cool idea. I think so. Excel can import .GIF images. GIF images support
transparency. Then it is a matter of designing the GIF so that it's size is
right and the cell size hole is right. Also, you would have a problem
"Clicking" in the cell afterwards because the image would be in front of it.
However, if all you do is use the cell the output values, then it should be
fine.



"Dan Tabla" wrote in message
...
There is any way to make a hole in a picture and that hole should be
exactly
on top of an Excel Cell?

.


.