Goto method fails when assigning a macro to a button

  • Thread starter Thread starter Deanne
  • Start date Start date
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
 
Change the Takefocusonclick in the properties off the button to false
and try again.

This is a bug in Excel 97
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with "Application.Goto Reference" code line 4
excel macro question 0
error 1004 6
Unexpected Error 3
Application.top=0 fails 3
Run-time-error 1004 "ListIndex method of listbox class failed" 1
Problem transferring Excel macros to another language 1
Goto Reference:="abc" where abc is formula result 5

Back
Top