message box when file is opened
 

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

message box when file is opened
 

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"oxicottin" wrote in message ...
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

message box when file is opened
 

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

"Ron de Bruin" wrote:

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"oxicottin" wrote in message ...
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

message box when file is opened
 

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"oxicottin" wrote in message ...
works great! Is there some way I can make my box larger?

"Ron de Bruin" wrote:

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"oxicottin" wrote in message ...
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

message box when file is opened
 

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

"Ron de Bruin" wrote:

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"oxicottin" wrote in message ...
works great! Is there some way I can make my box larger?

"Ron de Bruin" wrote:

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"oxicottin" wrote in message ...
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

message box when file is opened
 

No, use a userform if you want that

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"oxicottin" wrote in message ...
No I was just woundering! Is it possible to change the text color?

"Ron de Bruin" wrote:

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"oxicottin" wrote in message ...
works great! Is there some way I can make my box larger?

"Ron de Bruin" wrote:

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"oxicottin" wrote in message ...
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