Your original Post, reads that you have these command buttons,

Save your workbook in a different name you you can pratice using the M
a c r o R e c o r d e r

CHIP PEARSON WRITES

Posts: n/a
What is a macro?
A macro is a programmed procedure written in Visual Basic For
Applications (VBA). One uses macros to automate repetitive or
long sequences of operations. Thus, rather than carrying out a
long series of steps manually, you can call upon the macro to
perform the steps automatically.

To start with VBA, go to the Tools menu, choose Macro, then
Record. Carry out a series of actions. Then, stop recording.
Press ALT+F11 to open the VBA Editor. There, open Module1, and
examine the VBA code that was generated by the Macro Recorder.
The code isn't very efficient, but can give you a good idea of
what VBA and macros are all about.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Search for macro recorder in this forum and other places, like Excel's
help


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=523674