View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Colo[_59_] Colo[_59_] is offline
external usenet poster
 
Posts: 1
Default Workbook Deactivate Event

Hi

Please decrale a variable X as a Public as follows, and run
"InitializeApp"


Code:
--------------------

Public X As New EventClassModule

Sub InitializeApp()

Set X.App = Application

End Sub

--------------------



---
Message posted from http://www.ExcelForum.com/