D
davegb
I have code that shows a specific commanbar when a particular worksheet
is activated, then hides the commandbar when the spreadsheet is
de-selected. I want to save the commandbar name so that when the
spreadsheet is closed, the last commandbar will be hidden. But I'm
getting the ever-present "Object or withblock variable not set" error.
Here is the sheet code:
Private Sub Worksheet_Activate()
Application.CommandBars("Abuse").Visible = True
cTBar.Name = "Abuse"<----ERROR
Call TBarNameSave
End Sub
cTBar is publicly declared as a Commandbar. So why won't it accept the
name?
Thanks.
is activated, then hides the commandbar when the spreadsheet is
de-selected. I want to save the commandbar name so that when the
spreadsheet is closed, the last commandbar will be hidden. But I'm
getting the ever-present "Object or withblock variable not set" error.
Here is the sheet code:
Private Sub Worksheet_Activate()
Application.CommandBars("Abuse").Visible = True
cTBar.Name = "Abuse"<----ERROR
Call TBarNameSave
End Sub
cTBar is publicly declared as a Commandbar. So why won't it accept the
name?
Thanks.