Goto method fails when assigning a macro to a button
 

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

Goto method fails when assigning a macro to a button
 

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

This is a bug in Excel 97

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Deanne" wrote in message ...
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