Macros in Excel

  • Thread starter Thread starter Karen
  • Start date Start date
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.
 
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
 
As always, copy/paste (do not attach workbook) your code for comments
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel Macro Warning problems 1
Disable Macro Alert 2
Excel Macro-enabled Workbook 2
Excel 2007: Saving a file with a Macro 1
Oops sent to wrong forum: Excel Macros 2
Excel TWO Instances of Excel One watching Other 3
Macro - Excel 2003 3

Back
Top