When you press RecordMacro, a dialog box opens on which there is a
drop
down that lets you select what workbook the code is to be put in. It
also allows you to specify the name of the about to be recorded
macro.
Once you are done recording the macro, if you invoke the RunMacro
dialog
box, you can select the macro, press Edit and you will be taken to
that
macro in the VBEditor, which will let you see what module (in the
VBProject you selected from the Record Macro dialog) your macro was
put
in.
Well stated!
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion