MACRO - HELP!!!

  • Thread starter Thread starter Lianne
  • Start date Start date
L

Lianne

I have a spreadsheet that uses a macro to run. I have
copied the s/s and the macro in order to make
modifications without changing the original info.
However, the s/s is still referencing the original
macro. There are no links in the s/s. I would REALLY
aappreciate any help.

Thank you!
Lianne
 
With Excel open, hit Alt+F11. Go to Tools>>Macros, and find your macro on
the list. Click it ONCE and select EDIT. Find the line of code that
references which workbook to use and change it to point to the workbook you
want. If you're not sure of what to do, copy the whole macro and paste it
into a post here that explains the problem.

HTH
Ed
 
To help find those pesky links:

Bill Manville's findlink.zip from:
http://www.BMSLtd.co.uk/MVP/Default.htm

And how do you run those macros? Do you have buttons/objects that have macros
assigned to them? If yes, are they pointing at the current workbook?

And same thing if you're using toolbar icons to run your code.

And do you really mean references?

Go to the VBE (alt-F11) (where macros live)
hit ctrl-R to see the project explorer
select your project (should look like: VBAProject (yourfilename))

Now click on Tools|references.
do you really have a reference to that other workbook?
 
Back
Top