Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I insert a message when a user opens my Excel workbook?
|
#2
|
|||
|
|||
Hi KP,
Try: something like: '================ Private Sub Workbook_Open() MsgBox "Hello from KP!" End Sub '================ This is workbook event code and should be pasted into the workbook's ThisWorkbook module *not* a standard module or a sheet module): ************************************************** ** Right-click the Excel icon on the worksheet (or the icon to the left of the File menu if your workbook is maximised) Select 'View Code' from the menu and paste the code. Alt-F11 to return to Excel. If you are not familiar with 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 --- Regards, Norman "kp5689" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
allow user to disable annoying warning dialog on log charts | Charts and Charting in Excel | |||
Excel opens correct view - web (used frontpg) opens it wrong | Excel Discussion (Misc queries) | |||
Insert Outlook Message into Excel cell | Excel Discussion (Misc queries) | |||
insert a user's name/id | Excel Discussion (Misc queries) | |||
File is locked for Editing by user problem | Excel Discussion (Misc queries) |