View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CM CM is offline
external usenet poster
 
Posts: 136
Default reset hidden commandbars using workbook_beforeclose()

I am using workbook_open to hide commandbars. I am using workbook_beforeclose
to reset them.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Ply").Enabled = True
Application.CommandBars("Toolbar List").Enabled = True
End Sub

The problem is that when I choose to 'Cancel' out of closing the workbook,
the reset happens anyway and all of the command bars are visible. Pleas
advise on a solution.

cm