nigelandrewfoster
Well-known Member
- Joined
- May 27, 2009
- Messages
- 747
Hi,
Been puzzled this afternoon. Took my old, cumbersome ordering system apart today, starting almost from scratch. One macro which I completely rewrote is called UpdateAll, which I assigned to upper case U on keyboard. This was the same assignment I had for the old Update macro, which - along with almost everything else today - has been deleted. HOWEVER... When I try to run the macro using UCase U, I get strange results. When I run the macro by selectiong it and hitting run it works ok. I reassigned the macro shortcut to LCase u and, again, it worked ok. IT SEEMS like its running an old macro from an old workbook, somewhere, when I hit Ucase U, but none are open. How could I discover what it's doing? I tried stepping through the code several times, and it seems to behave itself when it's under scrutiny, like most of us, I guess.
Been puzzled this afternoon. Took my old, cumbersome ordering system apart today, starting almost from scratch. One macro which I completely rewrote is called UpdateAll, which I assigned to upper case U on keyboard. This was the same assignment I had for the old Update macro, which - along with almost everything else today - has been deleted. HOWEVER... When I try to run the macro using UCase U, I get strange results. When I run the macro by selectiong it and hitting run it works ok. I reassigned the macro shortcut to LCase u and, again, it worked ok. IT SEEMS like its running an old macro from an old workbook, somewhere, when I hit Ucase U, but none are open. How could I discover what it's doing? I tried stepping through the code several times, and it seems to behave itself when it's under scrutiny, like most of us, I guess.
Last edited:
