Hi Sam:

I use the Recorder out of habit for certain tasks. Applying formats to
pivot tables, for example.

b.t.w

Don't let the Gold fool you. I am, after all, still only a Student.
--
Gary''s Student - gsnu200909


"Sam Wilson" wrote:

You could specify a cetain name for the macro and then have an extra macro
(with a reference to the VBA extensibility module) which moves the recorded
macro (based on its name) to a module of your choice.

Are you not a bit beyond recording macros as a gold contributor?

Sam


"Gary''s Student" wrote:

When I record a macro, the dialogbox allows me to specify the macro's name
and a shortcut key.

How do I specify in which of the existing modules the newly recorded macro
should be placed?
--
Gary''s Student - gsnu200908