I have several macros in my Excel 2003 that work fine when run manually (either F5 or F8), but when run from a forms button, do something different, such as jump to the wrong cell. I usually don't have a problem with using a button.
You need to check that macro formula is correct for the button application & matches the key formula exactly.
Does the Macro have Active Cell (where the cursor needs to be in order for the Macro to run correctly) at the top of the Macro or is the cell hard coded?
Thanks for the quick reply. Not sure what you mean by "You need to check that macro formula is correct for the button application & matches the key formula exactly.". I wrote a macro and assigned it to a button and it worked ok, but now doesn't. Note that it works manually just fine. Also note that the cursor has to be in the correct cell for it to start, but I'm sure it is, as that is the most convenient way for this macro to be used. As for the ActiveCell comment, here is the first line:
ActiveCell.Offset(-1, 1).Range("A1").Select Why did it work before and not now? I must have changed something.
Hi ah100,
Basically, what that line of code does is, wherever the cursor is in the SpreadSheet it goes 1 cell up and 1 cell to the right.
Why don't you just hard code the actual cell you want to start the Macro in.
I assume that your Macro has been recorded?
I hope this helps!
I use the offset command because I don't start in a particular cell, but offset (-1,1) locates the right cell. I have done some adding and removing of whole rows and wonder if maybe there is some confusion in the macro on what to do. Will investigate. Funny that it works manually, but not with the button.
Quote