My preference is to use a button from the Forms toolbar rather than the
Control Toolbox equivalent. If you go that way, after you draw the button
on a sheet the Assign Macro dialog will appear automatically and all you
have to do is click on the name of your recorded macro.

--
Jim
"sammy2x" wrote in
message ...
|
| Hi,
|
| I've been using excel for a while, but never really used VB. I have
| recorded a Macro, and all I want to do is put a command button on the
| sheet to run the Macro, ameteur question I know, but I have no idea how
| to write the VB Script!!
|
| Cheers,
|
|
|
| Sam.
|
|
| --
| sammy2x
| ------------------------------------------------------------------------
| sammy2x's Profile:
http://www.excelforum.com/member.php...o&userid=29674
| View this thread: http://www.excelforum.com/showthread...hreadid=496922
|