Macros in Excel

I have a question about macros...why does Excel open a
workbook for a macro? I created 2 of them (I'm a beginner
with Excel macros) and I noticed that when I run a macro
another workbook opens with the macro name.

Is there any way to prevent this annoying feature? I used
to macros in WordPerfect eons ago and this never was an
issue.

Hi Karen,
Don't you want to be able to use the macro in *any* workbook.
To me that is what macros are all about, extending Excel, to
provide facility that is not there, or should have been there.

Correctly installed into personal.xls you would not see the
extra workbook because it would be hidden.

Getting Started with macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Karen" wrote in message ...
I have a question about macros...why does Excel open a
workbook for a macro? I created 2 of them (I'm a beginner
with Excel macros) and I noticed that when I run a macro
another workbook opens with the macro name.

Is there any way to prevent this annoying feature? I used
to macros in WordPerfect eons ago and this never was an
issue.

As always, copy/paste (do not attach workbook) your code for comments

--
Don Guillett
SalesAid Software

"Karen" wrote in message
...
I have a question about macros...why does Excel open a
workbook for a macro? I created 2 of them (I'm a beginner
with Excel macros) and I noticed that when I run a macro
another workbook opens with the macro name.

Is there any way to prevent this annoying feature? I used
to macros in WordPerfect eons ago and this never was an
issue.