Jeff,
In the Code window of "ThisWorkbook" in the VBA Editor (Click on
"ThisWorkbook" and press F7), paste the following (for example)
Private Sub Workbook_Open()
'MsgBox ("Good Morning - I'm Open!")
CreateObject("WScript.Shell").Popup "Hello!", 1, " Hello for 1 second! "
End Sub
To run a macro before the workbook closes, try:
Private Sub Workbook_BeforeClose(cancel As Boolean)
'MsgBox ("Leaving Workbook - Goodbye!")
End Sub
And to run code when a particul;ar worksheet is opened or closed, try
pasting these into their code windows in the same way as shown above, by
clicking on the worksheet name and pressing F7
None of these will work if they're in a normal module - they have to be in
the module for the workbook or the appropriate worksheet.
Private Sub Worksheet_Activate()
MsgBox ("Activating Sheet 1!")
End Sub
Private Sub Worksheet_Deactivate()
MsgBox ("Leaving Sheet 1!")
End Sub
Hope these help
Pete
The Createobject is nothing to do with this, it's a handy way of puting a
wait into a macro - the '1' is the number of seconds for which the delay
lasts.
