I want the spreadsheet to show an specific message when opening the file. Is
it possible?

Thank you,

R.

Here is some code that needs to be pasted into ThisWorkbook (Right click the
Excel Icon in the uper left corner of the Excel Screen -View Code -Paste
this code)

Private Sub Workbook_Open()
MsgBox "Here is my message", vbInformation, "Tada"
End Sub
--
HTH...

Jim Thomlinson


"R." wrote:

I want the spreadsheet to show an specific message when opening the file. Is
it possible?

Thank you,

R.

Hi R,

In the workbook's ThisWorkbook module:


Private Sub workbook_Open()

Msgbox "Your designated message"

End Sub


---
Norman


"R." wrote in message
...
I want the spreadsheet to show an specific message when opening the file.
Is
it possible?

Thank you,

R.