When I am in my developer mode I do what code additions or changes i need to do then go back to Excel worksheet to execute a command button to test it. Now nothing ever fails, and when you get through laughing, read on. If, or rather when an error occurs (who knew spelling could be such a problem) I go back to VBE and fix it. When I go back to worksheet to run it, it won't. OOOOPs - forgot to "reset" the run command in VBE. So back I go just to do a reset.
Now the question - is there a way to do that reset without going back to VBE. It seems everything gets frozen until the reset is executed which kind of eliminates running another macro from the worksheet to do the reset, but how about a keyboard combo?
Now the question - is there a way to do that reset without going back to VBE. It seems everything gets frozen until the reset is executed which kind of eliminates running another macro from the worksheet to do the reset, but how about a keyboard combo?