Hi,
I have been trying to get the following piece of code to work (it's part of a much larger sub from the MS KB) that calls on a function AddRemoveButton but when I perform the action I get the message "The macro cannot be found or has been disabled because of your security settings" (security is set at "low")
I have tried:Code:With CBarCtl
.Caption = "Drop Down"
.Width = 100
.AddItem "Create Button", 1
.AddItem "Remove Button", 2
.DropDownWidth = 100
.OnAction = "=AddRemoveButton()"
End With
and still get the error message - any other suggestions anyone?Code:.OnAction = "=AddRemoveButton()"
.OnAction = "AddRemoveButton()"
.OnAction = "AddRemoveButton"
.OnAction = AddRemoveButton
Thank you,
John :bink: