Lost Macro

[Michael Koerner]

In 2003, I used to have a macro that after I ran a merge into a table, run
the macro that would, when placed in the first cell of the table:

Insert a new row,
Combine and Center (vertically and horizontally) all the cells in that row,
Put a border around the Cell and fill it with 10% grey, and set it to Bold
and enter the first Alpha Character for the whatever name was in the
beginning cell.
The macro would insert this row, insert the alpha character every time the
first letter in the first column changed. Which looked something like this

-------------------
A
------------------
Adams
Armstrong
-----------------
B
-----------------
Brown...


Unfortunately, when I inserted office 7 that macro can no longer to be
found. I have in 2007 using the create macro thingy created a macro which
will put in the new row wherever I put the cursor and run the macro. Would
really like to automate the process again if possible. any help would be
greatly appreciated. TIA

 

[Cindy M.]

Hi Michael,

In 2003, I used to have a macro that after I ran a merge into a table, run
the macro that would, when placed in the first cell of the table:

Insert a new row,
Combine and Center (vertically and horizontally) all the cells in that row,
Put a border around the Cell and fill it with 10% grey, and set it to Bold
and enter the first Alpha Character for the whatever name was in the
beginning cell.
The macro would insert this row, insert the alpha character every time the
first letter in the first column changed. Which looked something like this

-------------------
A
------------------
Adams
Armstrong
-----------------
B
-----------------
Brown...


Unfortunately, when I inserted office 7 that macro can no longer to be
found. I have in 2007 using the create macro thingy created a macro which
will put in the new row wherever I put the cursor and run the macro. Would
really like to automate the process again if possible.

Inserted Office 7? I suppose you mean installed Office 12 (=2007)?

Don't you back up your templates occasionally? Especially Normal.dot (in which
I assume the macro was created)?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail