Question about personal.xls workbook.

Entering the code below in the personal.xls workbook will activate th
message box every time I open any Excel application.

Public Sub Workbook_Open()
MsgBox ("Hello")
End Sub

However, when I enter the following code in the personal workbook i
will not automatically activate the msgbox before print and befor
close.

Sub Workbook_Activate()
MsgBox ("Print")
End Sub

Public Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox ("goodbye")
End Sub

Why is this and how can I program a certain event to happen befor
printing and closing for all workbooks?

Thanks,
Bria

--
Brian257
-----------------------------------------------------------------------
Brian2577's Profile: http://www.excelforum.com/member.php...fo&userid=2971
View this thread: http://www.excelforum.com/showthread.php?threadid=49427