I have a macro in Excel that works just fine when I run it from the toolbar.
However, when I create a CommandButton on the spreadsheet itself and copy the
code from the macro, it will not run as hit encounters an error and goes into
debugging. Can anyone shed any light on this as to why and what I have to do
to fix it? Thanks so much...