Sorting macros

[Paul B]

Just to report a pleasant surprise. I sorted my macros using
Word's Outline View. Everything worked very nicely. I did lose
most of the keyboard shortcuts to the macros for some reason, but
that was easy to repair.

But the nice thing was that now the listing of macros in the
Keyboard Customization dialog doesn't have the lengthy
"normal.dot.modules.newmacros....."(or whatever it is) prefix
taking up 95% of the list box's visual area. It's just the simple
macro names and it's much easier to find the ones I'm looking
for.

I have no idea why that is.

p.

 

[Paul B]

I spoke too soon. That long prefix is back in the list box. Still
nice to have the macros sorted though.

p.

 

[Pablo Cardellino]

Hi, Paul,
you could do this to short that long prefix:

1. Create a new template named, for example, MyMacros.dot
2. Whitin the Visual Basic window will appear an item named "Project
(MyMacros)". Right click this project and select Properties. In the dialog,
name the project to a very short name, as "MM", and click OK.
3. Now, select New > Module, and a module named Module1 will appear under
MM.
4. Select this module, and rename it using the Properties window (F4). Use
another very short name, as "M".
5. Move all your Normal.dot macros to this module.

Now, that very long prefix will appear just "MM.M.". If you want, you can
(and often you should) use more descriptive, not so short names, but for a
generic macros module, this could work.

Best regards,

Pablo Cardellino
Florianópolis, SC
Brazil

 

[Paul B]

Hi Pablo,

Thanks for that. It sounds like a good idea, but would docs based
on my normal.dot see macros stored in a different template?

As to the problem, for some reason, when I just went to reassign
a keyboard shortcut to a macro, the macro names were again in
their short form. What is causing them to appear that way only
sometimes puzzles me.

Take care,
p.