Home |
Search |
Today's Posts |
#1
|
|||
|
|||
want to create a message box to appear on open
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? |
#2
|
|||
|
|||
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 "Fionajpower" wrote: 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? |
#3
|
|||
|
|||
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 --- Regards, Norman "Fionajpower" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i create a shortcut to open a spreadsheet read only? | Excel Discussion (Misc queries) | |||
Check box and and formula | Excel Discussion (Misc queries) | |||
Can't open any files due to my non-existant virus scanner | Excel Discussion (Misc queries) | |||
Trying to open Excel/Word files error message "Unable to read file | Excel Discussion (Misc queries) | |||
Cannot open a file that Excel says is open | Excel Discussion (Misc queries) |