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

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

Thank you,

R.

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

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.

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

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.