want to create a message box to appear on open

F

Fionajpower

I want to be able to have a Message appearing the first time o open a
worksheet in an excel document or even have appear when the document
opensinitially.
can this be done easily and removed easily?
 
D

David Hepner

Private Sub Workbook_Open()
'Place this code in the ThisWorkbook object
MsgBox "Insert your message here", vbInformation, "Insert your message box
title here"

End Sub
 
N

Norman Jones

Hi Fiona,

Paste the following code into a standard module in the workbook:

Sub Auto_Open
Msgbox "Hi from Fiona!"
End sub

If you are new to macros, you may wish to visit David McRitchie's 'Getting
Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

For your immediate purposes, however:

Alt-F11 (to open the Visula Basic Editor)
Alt IM (to insert a new module)
Paste the code at the cursor point
Alt-F11 (to return to Excel)
Now, whenever the workbook is opened, the greeting will appear.

To delete the macro, in Excel:

Alt-F8 (opens the Macro dialog box)
Select 'Auto_Open) in the dropdown list
Hit the dialog's Delete button
 
Top