Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook Open code
Use this code in the Microsoft Excel Object called "ThisWorkbook"
Private Sub Workbook_Open() MsgBox ("Hello") End Sub "Neal" wrote in message ... Dear experts, I am using Excel 97. When the user opens the workbook, I would like to have a message box appear and also clear out some cells from a previous user. I already have the code for the macro, but how do I have this happen when the workbook is opened? Thanks in advance. Neal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i open a second workbook using a vba code | Excel Discussion (Misc queries) | |||
How to code VBA: Auto open workbook and run macro | Excel Discussion (Misc queries) | |||
Need VB code for workbook open to open a link | Excel Discussion (Misc queries) | |||
Need VBA Code to Open a Workbook in read only | Excel Discussion (Misc queries) | |||
Workbook Open code | Excel Programming |