Creating a Pop-up Box

[Needshelp]

Is there a way to add a pop-up box when a spreadsheet is opened? If there is a way to do this without a macro is would be the best. I need a pop-up box to come up asking users if they opened the excel file from a specific location to make sure they have the most up-to-date version. Thanks for the help!

[nawas]

something like this..

Private Sub Workbook_Open()

MsgBox "Please Update"

End Sub

[Needshelp]

Can you be more specific? I have a moderate amount of excel experience but it's mostly in finance-related work - I have no idea how to try what you suggested. Thanks for the help!

[jj72uk]

nawas gave you a good answer, you'd need a macro which would run automatically when the workbook is opened.

Copy the code into the 'this workbook' VBA section and subsitute your own personal message.

Attached is an example. You can gain access to the VBA editor by pressing Alt+F11

[Needshelp]

Thanks to both of you. That works perfect!