need help with macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 > macro > macros
you should see the name of the macro created already there and you should
just be able to click the "run". But the name of the macro is not there and
the "run" 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.
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 > macro > macros
you should see the name of the macro created already there and you should
just be able to click the "run". But the name of the macro is not there and
the "run" 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.
Click to expand...
 
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
 
Back
Top