Excel Macros

[Dar]

Hi: I have a workbook with 14 worksheets. I need 14 macros

I want the name of the macro to be the name of each worksheet. ex. FA2E,
FA3E, FA4E, etc. the macro is the same except for referencing the worksheet
name.
I have the first macro and am copying/pasting 14 times, changing the
worksheet name and macro name.
However, it doesn't work properly. About the 5 copy/past excel seems to
want to call the macro by the name of the workbook, dot, worksheet. What am
I doing wrong.
When I open up tools, macro, I want to see the 14 names as stated above.
Because, I have a final macro that calls each macro, so I would call,
FA23, FA3E etc.

Help would be appreciated.

 

[Tom Willett]

You need to ask in an Excel newsgroup, not the FrontPage web client
newsgroup.

--
Tom [Pepper] Willett
Microsoft MVP - FrontPage Since 1997
---------------------------
: Hi: I have a workbook with 14 worksheets. I need 14 macros
:
: I want the name of the macro to be the name of each worksheet. ex. FA2E,
: FA3E, FA4E, etc. the macro is the same except for referencing the
worksheet
: name.
: I have the first macro and am copying/pasting 14 times, changing the
: worksheet name and macro name.
: However, it doesn't work properly. About the 5 copy/past excel seems to
: want to call the macro by the name of the workbook, dot, worksheet. What
am
: I doing wrong.
: When I open up tools, macro, I want to see the 14 names as stated above.
: Because, I have a final macro that calls each macro, so I would call,
: FA23, FA3E etc.
:
: Help would be appreciated.
: