View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex St-Pierre Alex St-Pierre is offline
external usenet poster
 
Posts: 169
Default Workbook_Open CommandBar corrupt excel files

Hi,
I have 2 macros that create and delete a custom command bar at the opening
and before close.
A) When I save the file and then click on "X" without saving, I can reopen
the file.
B)But when I save the file, click on "X" and click on save, I can't reopen
the file (Excel ask to recover the file).
Does anyone have an idea?
Thank you!
Alex
Private Sub Workbook_Open()
Call CreateCommandBar
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call DeleteCommandBar
End Sub
--
Alex St-Pierre