Macros in Excel

K

Karen

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.
 
D

David McRitchie

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
 
Top