| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Does not Work on Button
I have recorded a GoalSeek macro in Excel 97 SR2, which works when
called from the Tools | Macro menu, but when I call it from a button on the spreadsheet then the macro fails in the GoalSeek command. My macro is . . . Sub BalancePC() ' ' BalancePC Macro ' Macro recorded 24/03/2009 by Alan G Lloyd ' ' Worksheets("Financial Statement").Range("M37").GoalSeek _ Goal:=0, _ ChangingCell:=Worksheets("Financial Statement").Range("I25") End Sub Alan Lloyd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Button in a work sheet | Excel Discussion (Misc queries) | |||
| U.S. Command Button Macro won't work in Australian version 2003 | Excel Discussion (Misc queries) | |||
| Button suddenly does not work | New Users to Excel | |||
| Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
| Assign Macro to button in Excel doesnt work Any ideas? | Excel Discussion (Misc queries) | |||
Threaded Mode
