![]() |
workbookopen doesn't function
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 procedu Sub InitializeApp() Dim X As New EventClassModule Set X.App = Application End Sub Does anybody know why the macro isn't run anymore? -- Message posted via http://www.officekb.com |
All times are GMT +1. The time now is 02:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com