View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Papou Papou is offline
external usenet poster
 
Posts: 56
Default 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