ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Workbook_Open and Workbook_BeforeClose not working (https://www.excelbanter.com/excel-programming/306540-workbook_open-workbook_beforeclose-not-working.html)

Don[_19_]

Workbook_Open and Workbook_BeforeClose not working
 
I have these in the ThisWorkBook module however neither appear to activate.
I am using a XP OS with Excel 2002. Any help explaining why these will not
call the appropriate subs in appreciated. TIA.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
' Removes custom icons

Call reset_toolbar

End Sub
-----------------------------------------------
Private Sub Workbook_Open()
' Inserts custom icons for this workbook

Call Popup_warning
Call Icon_insert

End Sub




All times are GMT +1. The time now is 04:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com