Macro using Command Button Vs. Ctrl Key
Posted by Marianne on January 11, 2001 10:35 AM
Hello,
I originally wrote a macro and had it work when Ctrl m was typed. Now, I recently discovered that I can insert Command Buttons in my worksheet. I thought that I would be able to use the same macro for the Command Button but it does not work. I am very new at this, so bear with me. Here is an example of where it gets hung up.
'Note: I am in worksheet 1.
Sheets("Worksheet 2").Select
Rows("10:10").Select
The code goes on, but I can't get past the Rows command with the Command Button and it works fine with Ctrl m.
Is there an explanation for this? Like for instance, is macro coding different when you are using VB command buttons?
Thanks,
Marianne