Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show Image When File Opened
How do I show a logo image for a few seconds each time a file is
opened? Cheers Tony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show Image When File Opened
Here are two ways...
This link describes how to create a splash screen userform on which you could display the logo image: http://www.xldynamic.com/source/xld.xlFAQ0007.html Or, you could do something like the following: Add the logo image to a blank worksheet in the workbook. Turn off the gridlines on the sheet (Tools Options View. Uncheck Gridlines, then click OK.) Name the sheet MsgSht. Paste the following code in the ThisWorkbook module: Private Sub Workbook_Open() Sheets("MsgSht").Visible = xlSheetVisible Sheets("MsgSht").Activate Sheets("MsgSht").ScrollArea = "A1:O31" Application.Wait Now() + TimeValue("0:00:03") '3 seconds Sheets("MsgSht").Visible = xlVeryHidden Sheets("Sheet1").Activate End Sub Change Sheet1 to whatever sheet should be displayed after the warning. Adjust the ScrollArea setting, if necessary. If you are new to macros, this link to Jon Peltier's site may be helpful: http://peltiertech.com/WordPress/200...e-elses-macro/ Hope this helps, HUtch "bony_tony" wrote: How do I show a logo image for a few seconds each time a file is opened? Cheers Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform won't show when file re-opened | Excel Discussion (Misc queries) | |||
stop excel file opened as read only if already opened by another u | Excel Programming | |||
My Excel Sheet has opened as a mirror image - Column A is on the . | Setting up and Configuration of Excel | |||
Export the worksheet background image as an image file - possible? | Excel Programming | |||
Show image | Excel Programming |