Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Question, why did Private Sub Workbook_Open()
not work? I have used it many times before and it worked fine. But on this project it would not work, but if I put in an Sub Auto_Open () routine it works fine. ---- this does not work in the ThisWorkbook Private Sub Workbook_Open() MsgBox "Application Opened ThisWorkbook" ' put in to debug Display_UnitInfo End Sub ----- But this does work on Module1 Sub Auto_Open() Display_UnitInfo MsgBox "Application Opened ThisWorkbook" ' put in to debug End Sub I can live with it, but curious why as to the Workbook_Open() stopped working in this project. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Private Sub Workbook_Open() doesn't run | Excel Discussion (Misc queries) | |||
Function in xl2003 not working in xl97 | Excel Discussion (Misc queries) | |||
Cannot get Auto_Open or Private Sub Workbook_Open() to run at star | Excel Programming | |||
Private Sub Workbook_Open() not running on open | Excel Programming | |||
Macro created in XL2000 not working in XL97 | Excel Programming |