M
mango
Dear All, may i know if i need to create the customised toolbar and button at
user's excel before they can use? I have about 20 users sharing this
application and not all users allowed to use the commandbar. only authorised
user can use the commandbar. if i do not create for those unauthorised user
then they will face run time error as button not at their excel.
pls help.
thanks alot
Private Sub Workbook_BeforeClose(Cancel As Boolean)
disable
End Sub
Sub disable()
Dim cmd As CommandBar
Set cmd = Application.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 = Application.CommandBars("Tender Bar")
cmd.controls("&kc").Enabled = True
End Sub
user's excel before they can use? I have about 20 users sharing this
application and not all users allowed to use the commandbar. only authorised
user can use the commandbar. if i do not create for those unauthorised user
then they will face run time error as button not at their excel.
pls help.
thanks alot
Private Sub Workbook_BeforeClose(Cancel As Boolean)
disable
End Sub
Sub disable()
Dim cmd As CommandBar
Set cmd = Application.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 = Application.CommandBars("Tender Bar")
cmd.controls("&kc").Enabled = True
End Sub