Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning a macro to a button | Excel Worksheet Functions | |||
Assigning A Macro to A Button | Excel Worksheet Functions | |||
assigning macro to button | Excel Discussion (Misc queries) | |||
Assigning macro to button | Excel Discussion (Misc queries) | |||
Assigning a macro to a "button" | Excel Discussion (Misc queries) |