Goto method fails when assigning a macro to a button

D

Deanne

I have written a macro that includes a Goto Reference. If
I run the macro from the worksheet it works.

I want to assign this macro to a Command Button. The
result is a Run-time error '1004': Method 'Goto' of
object '_Application' failed.

Can any one suggest another way? My Goto Reference is a
named range of cells.

I use the outdated Excel 97.

Please help!

Thanks,

Deanne
 
R

Ron de Bruin

Change the Takefocusonclick in the properties off the button to false
and try again.

This is a bug in Excel 97
 
Top