Is your "list of macros" in Personal.xls?

I would paste the macro into a general module in the workbook you are running it
on.

With your workbook open...........

Alt + F11 to open VBEditor. CTRL + r to open Project Explorer.

Select your workbook/project and right-clickinsert module.

Paste the macro into that module.

Alt + F11 to return to the Excel window.

Select the sheet to run the macro on.

Does it run from ToolsMacroMacros?


Gord


On Tue, 8 Jul 2008 14:11:11 -0700, Old Bob
wrote:

Gord,
Please be patient..I have figured out how to just copy and paste your macro
and put it in my list of macros, adjusted my security, openend telling it to
allow macro. when I try to run I get this message "Sub or Function is not
defined"..any ideas?