All,
Not sure if this should go in the VBA section but I have some code that restores the Menu Bar during the Unload Event but when I hold the Shift Key to view tables and stuff I have no Toolbars. I have all the checkboxes marked under the Startup option and am not seeing the issue. Thoughts? I am using Office 2003 on XP.
Here is the code:
Private Sub Form_Unload(Cancel As Integer)
Dim i As Integer
On Error Resume Next
CommandBars("MyCustomToolBar").Delete
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = True
Next i
End Sub
Not sure if this should go in the VBA section but I have some code that restores the Menu Bar during the Unload Event but when I hold the Shift Key to view tables and stuff I have no Toolbars. I have all the checkboxes marked under the Startup option and am not seeing the issue. Thoughts? I am using Office 2003 on XP.
Here is the code:
Private Sub Form_Unload(Cancel As Integer)
Dim i As Integer
On Error Resume Next
CommandBars("MyCustomToolBar").Delete
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = True
Next i
End Sub
Last edited: