View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pd
 
Posts: n/a
Default Macro problem in Excel

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.