how to create a popup window in excel 2007

How to create a popup window in Excel 2007

Posted By quikStarts

This guide is part of the Microsoft Excel 2007 series

1. Delete a column in Excel 2007
2. How to add a background image to excel 2007
3. How to add a column to a spreadsheet in excel 2007
4. How to add a drop down list in excel 2007
5. How to add a URL to Excel 2007
6. How to auto fit column width in excel 2007
7. How to convert a column into a row in Excel 2007
8. How to create a drop down menu in Excel 2007
9. How to create a pie chart in Excel 2007
10. How to create a popup window in Excel 2007

Make: excel

Model / Product: Excel

Version: 2007

Objective / Info: Create a pop up window with a custom message when a workbook is opened.

Start Excel by clicking the icon on the desktop or start menu.

Open a new or existing worksheet.

In the Visual Basic Editor, paste the following code into the box to the right: Private Sub Workbook_Open() MsgBox "This is your personal message" End Sub

Note : Replace this portion "This is your personal message" with your own message.

Click the "Developer" tab on the menu.

Click the "Visual Basic" button.

Close the Visual Basic editor window by clicking the red x in the upper right hand corner.

Close the Excel file.

Note :Click "Save" if prompted.

Reopen the Excel file that you made the changes to. If Macros are disabled, you may see a security message. Click the "Options" button.

Note : I

Select the "Enable this content" option and click the "OK" button.

The pop up should appear with the message your created. Click "Ok" on the pop up to remove it. This task should be complete. If you did not get these results, review and repeat the steps.