Pop window fires when I open an excel workbook. That was what I meant.
Adding to that, I want to enclode some pictures within that pop up little
window, these pictures are stored on my desktop.
Finally, can I edit the duration of time this little window pops up for.
i.e. 5/6 seconds before it closes itself.
Thanks for giving me the hope by saying doable.
You can create a userform and add pictures to the userform.
*.bmp or *.jpg seem to work OK
NOTE: these will be embedded in the workbook with the userform so make them
email size like 420 x 320 or around 50kb
When workbook opens, the userform is loaded on screen.
OnTime code to set a duration of 6 seconds then userform closes.
All this is done through VBA.
Open a new workbook.
Alt + F11 to open Visual Basic Editor.
Insert>Userform and go from there.
Size to your needs.
From Control Toolbox select "Image"
Draw a box for your image size. Right-click and
Properties>Picture........browse to first picture and Open or double-click.
Now you have a picture on your userform.
Add more........save workbook regularly.
See VBA help for loading and unloading a userform.
Also see help for OnTime method for setting duration.
If you get stuck with any of this, email me at gorddibbATshawDOTca
I might get time to build you an example workbook.
Gord
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.