How to create a popup window in Excel 2007

How to create a popup window in Excel 2007
Posted By Kyle M. Brown List ViewGrid View

This guide is part of the Microsoft Excel 2007 series

Guides in this series:



Make: excel

Model / Product: Excel

Version: 2007

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


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

2
Open a new or existing worksheet.

3
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.

4
Click the "Developer" tab on the menu.
5
Click the "Visual Basic" button.

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

7
Close the Excel file.

  Note :Click "Save" if prompted.

8
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

9
Select the "Enable this content" option and click the "OK" button.
10
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.

Excel 2010 Crash-Course FREE!


Want to save the time you spend searching? Learn about our most requested guides on Excel 2010 in this totally FREE 5 part crash course.






|







comments powered by Disqus

Tag : excel

Ask a question or provide an answer

Posted Q&A(5)


Name
Email
URL
Comment
 
 
 
 




Excel 2010 Crash-Course FREE!


Learn about our most requested guides on Excel 2010 in this totally FREE 5 part crash course.






Search Tags

windows 7   Facebook login   windows xp   ftp   Google calendar sync   homepage   clear cache   ie 7   pdf   shapes   animate   image search   map   resolution   windows xp   Internet   computer   screenshot   word   chrome   encryption   temp files   toolbar   temp files   FireFox   google define   portable air conditoner   Smartrip Card   image   analytics   real time search   google docs   Gmail   archive   Paypal   spreadsheet   GOOG 411   publisher   boot cd   decrypt   email   screen recorder   skype setup   spreadsheet   picassaweb   clear history   outlook setup   hard drive   search history   zip   auto-save   ip address   comcast   dvr   caller id   Live movie maker   Mobify   IE 8   google voice   app inventor   rss   converter   netmeeting   wordpress   google tv   google toolbar   ipad   Google ebook   bookmarks   IE 9   android   Safari 5   facebook   Facebook login   KeepVid   PowerPoint   block calls   data recovery   angry birds   mac address   G2   photoshop   YouTube   clear history   xoom   Google Plus   FireFox 5   Google Translate   evernote   buffer   android development   HootSuite   uppidy   instagram   Google Drive   php and mysql   spreadsheet   Kojami   Excel to PDF   spreadsheet   Gmail Outlook 2010   Auto Archive Outlook   Outlook   Excel dashboards   Outlook   fitdivs   mailchimp   google-music   macbook-air   google-images   feedly   AirDisplay   outlook 2013   office-viewer   polaris-5   web-clipper   git   github

Thank you for reading.