Button Selection OnAction property
Grant
Sorry for the confusion
You should amend the WHOLE line from
Selection.OnAction = "Go_To(""Sheet1"")"
To
Go_To("Sheet1")
HTH
Cordially
Pascal
"Grant Reid" a écrit dans le message de
...
Hi Pascal
I made the suggested changes to my function and also the change to
Selection.OnAction = "Go_To(""Sheet1"")"
When I run the routine I get a '1004' run time error - Unable to set the
OnAction property of the Button class.
If I change it to
Selection.OnAction = Go_To("Sheet1")
I get '438' run time error - Object doesn't support this property or
method
Any ideas? Any help would be much appreciated.
Regards - Grant
|