Workbook_Open CommandBar corrupt excel files

  • Thread starter Thread starter Alex St-Pierre
  • Start date Start date
A

Alex St-Pierre

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
 
I think it's coincidence.

Try creating a test workbook with the same routines and save that. I bet it
works ok.

I'm betting that your workbook is corrupted--or on the cusp of being corrupt.
 
Back
Top