D
Dan Tabla
There is any way to make a hole in a picture and that hole should be exactly
on top of an Excel Cell?
on top of an Excel Cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
You would have to create a transparent section in the image, and then
the image would have to be Locked to the sheet. YMMV.
the image would have to be Locked to the sheet. YMMV.
H
Herbert Seidenberg
D
Dennis Tucker
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.
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.
D
Dan Tabla
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!
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!
D
Dan Tabla
Herbert this link is opening an example of a picture but is not explaining
anything.
anything.
G
Gord Dibben
Can you go to Format>Sheet>Background 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
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
D
Dan Tabla
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.
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.