pop-up message box

[leesl3]

how do you customize a message box to pop up once you open a file? i've tried writing a macro for this, but i have to get into the file first and then invoke the macro before the message box pops up.

Thanks.

 

[elgringo56]

put a macro in the woork book open area. That should do it

Private Sub Workbook_Open()
MsgBox "Hi"
Range("A1").Select
End Sub
This message was edited by elgringo56 on 2002-09-07 09:27

 

[leesl3]

No, I need a "warning" window to come up when a file is opened, kind of like how if a file contains macros from a different source, it pops up the macros warning window. That's like something what i need. Is there a way to do this?

Thanks.

 

[Juan Pablo González]

Yes, the MsgBox is what you need. Put it in the Workbook_Open() event.

 

[leesl3]

it worked! thanks alot!