Macro Recorder
 

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

Macro Recorder
 

AFAIK, you don't. You can always cut/paste it to the one you want.

"Gary''s Student" wrote in message
...
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

Macro Recorder
 

I think if it's the first macro you've recorded in the session, it creates a
new module. If you record multiple macros in the session, it saves them in
the same one. I've not seen any way to identify which module procedures are
stored in when recording.
--
HTH,

Barb Reinhardt



"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

Macro Recorder
 

Thanks
--
Gary''s Student - gsnu200908


"Bob Umlas" wrote:

AFAIK, you don't. You can always cut/paste it to the one you want.

"Gary''s Student" wrote in message
...
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

.

Macro Recorder
 

Thanks
--
Gary''s Student - gsnu200908


"Barb Reinhardt" wrote:

I think if it's the first macro you've recorded in the session, it creates a
new module. If you record multiple macros in the session, it saves them in
the same one. I've not seen any way to identify which module procedures are
stored in when recording.
--
HTH,

Barb Reinhardt



"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

Macro Recorder
 

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

Macro Recorder
 

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

What's a "gold" contributor?

Regards,
Peter T

Macro Recorder
 

It's some fluff MS built into their web interface for these newsgroups.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Peter T wrote:
Are you not a bit beyond recording macros as a gold contributor?

What's a "gold" contributor?

Regards,
Peter T

Macro Recorder
 

On Nov 20, 10:21*am, 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

Gary,

1. In Excel and close any open workbooks.
2. Open the .xla file.
3. Open the Visual Basic Editor.
4. In the VBAProject window, select the workbook for the xla file.
5. In the Properties window, change IsAddin from True to False.
6. Go back to the Excel Window.
7. On the Visual Basic toolbar, press the run macro button.
8. A list of macros should appear. Select the one that you want to
assign the shortcut to.
9. Press the Options Button.
10. Add the shortcut and press OK. Repeat for any other macros you
want to assign shortcuts.
11. Press Cancel.
12. Go back to Visual Basic Editor and make IsAddin True.
13. Close Visual Basic Editor.
14. Close Excel.
15 Save changes to .xla file.

Chuck

Macro Recorder
 

....and what's wrong with recording a macro now and then ?

Tim

"Jon Peltier" wrote in message
...
It's some fluff MS built into their web interface for these newsgroups.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Peter T wrote:
Are you not a bit beyond recording macros as a gold contributor?

What's a "gold" contributor?

Regards,
Peter T

Macro Recorder
 

Fluff is not all bad, either! <g



"Tim Williams" wrote in message
...
...and what's wrong with recording a macro now and then ?

Tim

"Jon Peltier" wrote in message
...
It's some fluff MS built into their web interface for these newsgroups.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Peter T wrote:
Are you not a bit beyond recording macros as a gold contributor?

What's a "gold" contributor?

Regards,
Peter T

Macro Recorder
 

When memory begins to fail, recording a macro can save time in finding
syntax for certain things. In this case, memory is neither RAM nor ROM.


"Sam Wilson" wrote in message
...
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

Macro Recorder
 

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