Show Image When File Opened

  • Thread starter Thread starter bony_tony
  • Start date Start date
B

bony_tony

How do I show a logo image for a few seconds each time a file is
opened?
Cheers
Tony
 
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/2008/03/09/how-to-use-someone-elses-macro/

Hope this helps,

HUtch
 
You must log in or register to reply here.

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.

Ask a Question

Similar Threads

Show Image When File Opened 2
PowerPoint High Resolution Images from PowerPoint 0
Replace the image in a "controlbox image".... 1
How to make web image on Excel worksheet permanent 3
Insert multiple .dat files into one pdf without losing color of their graphs 0
File Download - Security Warning 5
Add a picture image to the end of a Word document?!! 1
Getting the exposure right for night photography with a mobile phone. 7

Back
Top