where do you put programs?

[console1]

hi all

not clear where to put a program for excel.

i write it using the vbeditor, using the vba language but then.... where
do i put it? in a cell? in a macro? outside excel as a vbscript?


i'm confused


thanks]

 

[Guest]

From Excel:
Touch ALT-F11 to open VBE
Touch ALT-i
ALT-m

to open a fresh module.

Put your stuff in there.

 

[Jon Peltier]

If you've already written it in Excel's VBA Editor, then it is contained in
a workbook in Excel. That's where it stays.

- Jon