Creating User Messages that appears when opening an excel file 1

[petercav]

Hi There,

Does anyone know how to create message boxes that pop up when an excel file is open? Similar to when the "read-only" message that comes up sometimes, except that I want to put my own message in there that says "Please remember to do...."

Is this possible?

Anyones help is greatly appreciated

Thanks!

Petercav

 

[ETID]

You need to add this code to the vba editor...

alt+F11, the click the "thisworkbook" section under the Project - VBA Project window on the left

then paste this...

Private Sub Workbook_Open()
MsgBox ("My reminder text")
End Sub

 

[petercav]

thanks for that!

has helped out a lot!

Regards

Petercav