Welcome message in Excel

[5pds]

Hi can anyone help?

Can i write code to pop up with a message box when the file is opened and if so, how?

Thanks

Paul

 

[VoG]

Right click the Excel logo just to the left of File on the menu bar, select View Code and paste in

Private Sub Workbook_Open()
MsgBox "Hello and welcome!", vbInformation
End Sub

Save the workbook, close it and re-open it to see the effect.

 

[baitmaster]

macro named auto_open, or stored within ThisWorkBook module, on OPEN

either a message box (msgbox), or a user form, which can contain images, allsorts. I usually select a front page too, and check protection is applied correctly, that sort of thing

 

[5pds]

Thanks Chaps

 

[daffy]

baitmaster
could you please explain how to use a user form at start up and not a message box

thanks
don

 

[lenze]

Private Sub Workbook_Open()
UserForm1.Show
End Sub

lenze

 

[dave3009]

Splashscreen seems to be popular these days too, but I think it's based on Userforms

http://www.ozgrid.com/Excel/excel-splash-screen.htm