Have a Macro create a Macro

[Langy]

How do you create a VBA Macro to create a VBA Macro

When I run my Macro I want it to insert a button on a spreadsheet

Then insert code linked to that button which links to a Form

Insert a Form

Edit Form so it has appropriate buttons

Then Insert code into that form

 

[Tom Ogilvy]

http://www.cpearson.com/excel/vbe.htm

at Chip Pearson's site will give basic information on writing code with
code.

http://j-walk.com/ss/excel/tips/tip76.htm
at John Walkenbach's site shows how to create a form programmatically.

 

[Amedee Van Gasse]

http://www.cpearson.com/excel/vbe.htm

at Chip Pearson's site will give basic information on writing code
with code.

Don't use McAfee VirusScan ASaP if you use Chip's methods.