run time error using commandbar during before close

[mango]

Dear All, why beforeclose i got this message at set cmd = commandbars("Tender
Bar")
run time error 91
object variable or with block variable not set?

click commandbutton works fine.
pls help.
thanks



Private Sub Workbook_BeforeClose(Cancel As Boolean)
disable
End Sub

Sub disable()
Dim cmd As CommandBar
Set cmd = CommandBars("Tender Bar")
cmd.Controls("&KC").Enabled = False
End Sub


Private Sub CommandButton1_Click()
enable
End Sub

Sub enable()
Dim cmd As CommandBar
Set cmd = CommandBars("Tender Bar")
cmd.Controls("&KC").Enabled = True
End Sub

 

[Frank Kabel]

Hi
try if the following works:
Set cmd = application.CommandBars("Tender Bar")

 

[mango]

dear frank, it works! thanks alot. u r great!
what is the different between set cmd = commandbars("XX")
and set cmd = application.commandbars("XX") ??

 

[Frank Kabel]

Hi
it is just the full specification of the object reference. Always
better to do this