View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 141
Default Set Button Caption

I am trying to set button caption by using code but it is failing can someone
please point out what I should be doing

the error is Object Variable or With Block Variable not set



Dim mode As String
mode = EssVGetGlobalOption(5)
Set btn = Application.CommandBars.ActionControl
If mode = 4 Then
x = EssVSetGlobalOption(5, 2)
btn.Caption = "Warnings On"
Else
x = EssVSetGlobalOption(5, 4)
btn.Caption = "Warnings Off"
End If