View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Custom Messages in Excel

Hi,

Private Sub Workbook_Open()
MsgBox "Your message"
End Sub


change the message for yours, to enter the macro, right click on the mouse
over the tab name, view code, then at your upper left look for this workbook,
double click it and copy the above macro in the right side, close the VBA
application, then save the workbook as macro enable



"Mirandah" wrote:

How would you create a custom popup message in Excel. I want to create a pop
up message as someone is opening my file.