I have a subroutine which has the following:

VB Code:
  1. Public Sub ViewMenus()

  2. Dim Bar As CommandBar

  3.     CommandBars("Worksheet Menu Bar").Enabled = True

  4.     Application.DisplayFormulaBar = True

  5.     For Each Bar In Application.CommandBars

  6.         Bar.Enabled = True

  7.     Next Bar

  8.     CommandBars("Standard").Visible = True

  9.     CommandBars("Formatting").Visible = True

  10.     Application.CommandBars("Toolbar List").Enabled = True

  11. End Sub

Which I can call from anywhere. Works very well.
However, I am trying to call it from my BeforeClose Event, and the Command Bars aren't coming back. Any one know why this would be. I am trying to restore the Excel View to what it was prior to hidding all these bars.