ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Keeping images visible on sheets (https://www.excelbanter.com/excel-programming/358461-re-keeping-images-visible-sheets.html)

Mark Waiti

Keeping images visible on sheets
 
Thanks Dave

Our existing XL app is already automated with dynamic image field
highlighting (using msoshapes) as data is entered in each s/s column,
with auto-load of the next image and row
drop-down as each record is completed, and the previous image is tagged
as done, etc etc
etc.

We're committed to this functionality and format, and want to
effectively just add scroll and zoom to a picturebox. OLE embedding
should work. I seem to get the object embedded ok, but when I try to
insert the image or view it, it seems to open in a whole new unembedded
window, which disappears behind the XL sheet as soon as the sheet or a
cell gets focus.

Can you (or anyone, please) suggest code to keep the image visible while
users enter data into the cells, please?

Many thanks
Mark Lochore

*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT +1. The time now is 03:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com