How to create a message that appears when opening an excel file

[R.]

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

Thank you,

R.

[Jim Thomlinson]

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.

[Norman Jones]

Hi R,

In the workbook's ThisWorkbook module:


Private Sub workbook_Open()

Msgbox "Your designated message"

End Sub


---
Norman


"R." <[email protected]> wrote in message
news:[email protected]...
>I want the spreadsheet to show an specific message when opening the file.
>Is
> it possible?
>
> Thank you,
>
> R.