M
mika.
I used the following procedure to create a macro:
1. Open the workbook which contains the data.
2. Press ALT+F11 to activate the Visual Basic Editor.
3. Click Module on the Insert menu to insert a
module. Type the macro above in the module's code window.
4. Click Close and Return to Microsoft Excel on the
File menu.
However, when I try to do the following:
5. Point to Macros on the Tools menu and click Macro.
Select the macro, and click Run.
....I can't, because my macro is not listed! Any
suggestions as to why?
Thanks for the help.
1. Open the workbook which contains the data.
2. Press ALT+F11 to activate the Visual Basic Editor.
3. Click Module on the Insert menu to insert a
module. Type the macro above in the module's code window.
4. Click Close and Return to Microsoft Excel on the
File menu.
However, when I try to do the following:
5. Point to Macros on the Tools menu and click Macro.
Select the macro, and click Run.
....I can't, because my macro is not listed! Any
suggestions as to why?
Thanks for the help.