Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for Screenshot
Hi
I want to test for a simple two-part condition: I want to detect when there is a blank sheet with a screenshot pasted into it. I can do the first part but how do I detect the second, please? Thanks Tim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for Screenshot
I doubt if you can test if it is specifically a screen shot. You can test
if it is a picture ? activesheet.pictures.count I did a paste picture as link (which is what I assume you want to test for) With the result selected ? typename(selection) Picture I verified it was a linked picture as it updated when I changed a cell linked to the picture. Even so: ? activesheet.shapes(1).Type = msoLinkedPicture False ? activesheet.shapes(1).type = msoPicture True this was in xl97 - looks like a bug or there is another type of linked picture. If the picture is linked to another workbook there was no change, except there is a link shown in Edit=Links. Maybe someone else has a better way. -- Regards, Tom Ogilvy Tim Childs wrote in message ... Hi I want to test for a simple two-part condition: I want to detect when there is a blank sheet with a screenshot pasted into it. I can do the first part but how do I detect the second, please? Thanks Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Testing | Excel Discussion (Misc queries) | |||
TESTING | Excel Worksheet Functions | |||
Pasting Screenshot in shared workbook | Excel Discussion (Misc queries) | |||
Testing | Excel Discussion (Misc queries) | |||
Automatic screenshot in Excel | Excel Programming |