Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find and display a picture
I have a workbook with several sheets, each of which has several pictures.
Using VBA, I can activate the sheet that contains a given picture. But how can I scroll the sheet to display that picture? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find and display a picture
Try this. It wil find all shapes. You may need to check name of shapes to
see if they ae pictures verses other shapes. Sub abc() For Each MyPicture In Worksheets("Sheet3").Shapes Row = MyPicture.TopLeftCell.Row Column = MyPicture.TopLeftCell.Column Worksheets("Sheet3").Cells(Row, Column).Select Next MyPicture End Sub .. "Paul Pedersen" wrote: I have a workbook with several sheets, each of which has several pictures. Using VBA, I can activate the sheet that contains a given picture. But how can I scroll the sheet to display that picture? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
find and display a picture
That works nicely, thank you.
"Joel" wrote in message ... Try this. It wil find all shapes. You may need to check name of shapes to see if they ae pictures verses other shapes. Sub abc() For Each MyPicture In Worksheets("Sheet3").Shapes Row = MyPicture.TopLeftCell.Row Column = MyPicture.TopLeftCell.Column Worksheets("Sheet3").Cells(Row, Column).Select Next MyPicture End Sub . "Paul Pedersen" wrote: I have a workbook with several sheets, each of which has several pictures. Using VBA, I can activate the sheet that contains a given picture. But how can I scroll the sheet to display that picture? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to display a picture | Excel Discussion (Misc queries) | |||
Multiple Picture display | Excel Discussion (Misc queries) | |||
picture does not display in excel | Excel Discussion (Misc queries) | |||
How can I conditionally display one picture over another? | Excel Discussion (Misc queries) | |||
Display a picture depending on a value in a specified cell? | Excel Programming |