Dear Moderator/Excel gurus',
RE- Command Button Activation.
I have a silly little question as a beginner to VBA.
I have followed the steps in MS Excel 2002 Visual Basic handbook to learn how to perform a macro throught the use of a command button.
I cannot however get the command button to accept my 'Click' it always goes to the 'select' mode and gives me the 4 (East, west north south) mouse, as if I am trying to resize it. The macro works fine if I goto the editor and run it from there! (I do have 3 other macros in the spreadsheet but they are generated from 3 Ctrl-' ' keys not a command button.)
I have obviously, missed some 'flag' or is there a special way of saving the worksheet in order that the command button becomes 'live' ...so to speak!
Many, Many thanks!
DeanC
RE- Command Button Activation.
I have a silly little question as a beginner to VBA.
I have followed the steps in MS Excel 2002 Visual Basic handbook to learn how to perform a macro throught the use of a command button.
I cannot however get the command button to accept my 'Click' it always goes to the 'select' mode and gives me the 4 (East, west north south) mouse, as if I am trying to resize it. The macro works fine if I goto the editor and run it from there! (I do have 3 other macros in the spreadsheet but they are generated from 3 Ctrl-' ' keys not a command button.)
I have obviously, missed some 'flag' or is there a special way of saving the worksheet in order that the command button becomes 'live' ...so to speak!
Many, Many thanks!
DeanC