I need to creat a pop up window when I open an excel sheet.

I need to get a pop up window, with message and pictures, to open when I open
an excel sheet.
p.s. not advanced user.

One does not "Open" a sheet. One selects or activates a sheet within a
workbook.

Do you mean open a workbook?

This would require VBA event code which fires when the workbook is opened.

If you did mean "sheet" then sheet_activate event code could be used.

What type of pictures and where would they be placed?

Would the pictures be embedded in the workbook?

Perhaps explain a bit more about what effect you wish to achieve.

What you ask is doable.


Gord Dibben MS Excel MVP

On Thu, 5 Nov 2009 12:24:02 -0800, Strugling
wrote:

I need to get a pop up window, with message and pictures, to open when I open
an excel sheet.
p.s. not advanced user.

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.

"Gord Dibben" wrote:

One does not "Open" a sheet. One selects or activates a sheet within a
workbook.

Do you mean open a workbook?

This would require VBA event code which fires when the workbook is opened.

If you did mean "sheet" then sheet_activate event code could be used.

What type of pictures and where would they be placed?

Would the pictures be embedded in the workbook?

Perhaps explain a bit more about what effect you wish to achieve.

What you ask is doable.


Gord Dibben MS Excel MVP

On Thu, 5 Nov 2009 12:24:02 -0800, Strugling
wrote:

I need to get a pop up window, with message and pictures, to open when I open
an excel sheet.
p.s. not advanced user.

.

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.

InsertUserform and go from there.

Size to your needs.

From Control Toolbox select "Image"

Draw a box for your image size. Right-click and
PropertiesPicture........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

On Thu, 12 Nov 2009 04:39:01 -0800, Strugling
wrote:

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.

"Gord Dibben" wrote:

One does not "Open" a sheet. One selects or activates a sheet within a
workbook.

Do you mean open a workbook?

This would require VBA event code which fires when the workbook is opened.

If you did mean "sheet" then sheet_activate event code could be used.

What type of pictures and where would they be placed?

Would the pictures be embedded in the workbook?

Perhaps explain a bit more about what effect you wish to achieve.

What you ask is doable.


Gord Dibben MS Excel MVP

On Thu, 5 Nov 2009 12:24:02 -0800, Strugling
wrote:

I need to get a pop up window, with message and pictures, to open when I open
an excel sheet.
p.s. not advanced user.

.