View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default What determines location of VBA code from recorded macro?

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