View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don[_19_] Don[_19_] is offline
external usenet poster
 
Posts: 1
Default 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