message box when file is opened

[Guest]

Hello I have been serching around in this forum and dont really understand
how to do this. I want a pop up message to open when an .xls file is opened.
I did find someone wrote this. But I dont know how to do this I never messed
with macro ect. Can someone explaing in depthe how this is done? Thanks!!!!!

putn the following code in yopur workbook module ('ThisWorkbook'):
sub workbook_open()
msgbox "Now opening..."
end sub

 

[Ron de Bruin]

Hi oxicottin

Alt F11 to open the editor
To be sure you see all windows press one time Ctrl-R and F7

Double click on the ThisWorkbook module on the left in the project window
If you not see it click on the + before the project/file name

Then paste this in the code window

Private Sub Workbook_Open()
MsgBox "Hi"
End Sub

Then use Alt q to close the editor
Save/close and reopen the file now

 

[Guest]

works great! Is there some way I can make my box larger?

 

[Ron de Bruin]

Hi oxicottin

No, if you want that you must create a userform and open that when your workbook start.
What do you want to do, splash screen ?

See
http://www.j-walk.com/ss/excel/tips/tip39.htm

 

[Guest]

No I was just woundering! Is it possible to change the text color?

 

[Ron de Bruin]

No, use a userform if you want that