software

Hello folks. Cant say that I know much about macros. I am a computer support
technician trying to help someone who also does not have a strong
understanding of macros. I'll get right to it. The way this was explained to
me was that a macro was created in excel file #1. I am told that (and I have
observed this) when you open excel file #1 and excel file #2 (no macro
created in #2) and then go back to file #1 and click tools gt; macro gt; macros
you should see the name of the macro created already there and you should
just be able to click the quot;runquot;. But the name of the macro is not there and
the quot;runquot; button is greyed out. Again, this is how I am told it is supposed
to work. Does that seem right? I am told that for some reason that Excel is
not recognizing that file #1 has macros. I have opened those same files on 2
other machines with Excel 2003 and achived the same results. The only machine
that this works on is the original machine where the macro was created which
also has excel 2003. Any help on this would be greatly appreciated. Please do
not be hesitant to take me to beginners level on this. Thanks.

You have a guess at your other post in .misc.

pd wrote:
gt;
gt; Hello folks. Cant say that I know much about macros. I am a computer support
gt; technician trying to help someone who also does not have a strong
gt; understanding of macros. I'll get right to it. The way this was explained to
gt; me was that a macro was created in excel file #1. I am told that (and I have
gt; observed this) when you open excel file #1 and excel file #2 (no macro
gt; created in #2) and then go back to file #1 and click tools gt; macro gt; macros
gt; you should see the name of the macro created already there and you should
gt; just be able to click the quot;runquot;. But the name of the macro is not there and
gt; the quot;runquot; button is greyed out. Again, this is how I am told it is supposed
gt; to work. Does that seem right? I am told that for some reason that Excel is
gt; not recognizing that file #1 has macros. I have opened those same files on 2
gt; other machines with Excel 2003 and achived the same results. The only machine
gt; that this works on is the original machine where the macro was created which
gt; also has excel 2003. Any help on this would be greatly appreciated. Please do
gt; not be hesitant to take me to beginners level on this. Thanks.

--

Dave Peterson

Most likely the macro was created in the personal.xls which is a hidden
workbook that you can create when you record a macro, when doing so you are
prompted where you want to put the macro, either This, New or Personal Macro
Workbook. If you select the personal the macro will be open to all workbook
in this installation of Excel but if you move the workbook (email, copy etc)
to another computer with it won't be available. However if the macro was in
a particular workbook then the macro would follow that workbook. Also if
security is set to high it will ignore any macros. You can look at macros by
pressing Alt F11 to open the VBE, in the project pane to the left you will
see modules where normal macros are stored and also ThisWorkbook and the
sheet modules.

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;pdquot; gt; wrote in message
...
gt; Hello folks. Cant say that I know much about macros. I am a computer
gt; support
gt; technician trying to help someone who also does not have a strong
gt; understanding of macros. I'll get right to it. The way this was explained
gt; to
gt; me was that a macro was created in excel file #1. I am told that (and I
gt; have
gt; observed this) when you open excel file #1 and excel file #2 (no macro
gt; created in #2) and then go back to file #1 and click tools gt; macro gt;
gt; macros
gt; you should see the name of the macro created already there and you should
gt; just be able to click the quot;runquot;. But the name of the macro is not there
gt; and
gt; the quot;runquot; button is greyed out. Again, this is how I am told it is
gt; supposed
gt; to work. Does that seem right? I am told that for some reason that Excel
gt; is
gt; not recognizing that file #1 has macros. I have opened those same files on
gt; 2
gt; other machines with Excel 2003 and achived the same results. The only
gt; machine
gt; that this works on is the original machine where the macro was created
gt; which
gt; also has excel 2003. Any help on this would be greatly appreciated. Please
gt; do
gt; not be hesitant to take me to beginners level on this. Thanks.