message box when spreadsheet is opened

Question

i have a spreadhseet multiple users will be opening on a regular basis.  I would like to have a reminder pop up every time they open the sheet.  Is there any way to make that happen?

Answer 1

You can do it with some simple code. In the ThisWorkbook code module, use

Private Sub Workbook_Open()

MsgBox "Hello World"

End Sub

Answer 2

Open your spreadsheet

Actiate the developer tab, if you are unaware on how this is done simply go to Files -> Options -> Customize Ribbon

Under MAIN TABS on the right hand side, you will see that developer is unchecked. Check it and click Okay.

Click the newly displayed DEVELOPER TAB

Click Visual Basic

On the left hand side, you will see a folder stating Microsoft Excel Objects

Under this folder, you will see ThisWorkbook, click it.

After you have done so, paste this inside the form

Private Sub Workbook_Open()

MsgBox "This workbook is very important, so please read this message!"

End Sub

All you have to do is replace the message inbetween the quotes.

This is basically what Chip stated, however it does not appear that he accounted for the fact that because it is "simple code" the user on the other hand may not have any coding experience at all; the result would be you would be completely lost, even if he handed you that code.