If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
I need to creat a pop up window when I open an excel sheet.
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. |
#3
|
|||
|
|||
I need to creat a pop up window when I open an excel sheet.
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. . |
#4
|
|||
|
|||
I need to creat a pop up window when I open an excel sheet.
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. . |
Thread Tools | |
Display Modes | |
|
|