workbookopen doesn't function

  • Thread starter P Westerman via OfficeKB.com
  • Start date
P

P Westerman via OfficeKB.com

As newbee, I read the MSExcel-helpfiles on the WorkbookOpen event and it
did work for a short while. Strange enough it stopped working and I can't
find out why.
This is what I did:

STEP1: I created an Eventclassmodule ("EventClassModule") with the
following code:

Public WithEvents App As Application
Private Sub App_WorkbookOpen(ByVal Wb As Workbook)
Run ("check_user")
End Sub

STEP2: I ran the InitializeApp procedure:

Sub InitializeApp()
Dim X As New EventClassModule
Set X.App = Application
End Sub

Does anybody know why the macro isn't run anymore?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top