View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default 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.