How do I point a macro at the current workbook?

[Nobby]

I cut&pasted data from a copy of a master workbook. Both the master and the copy book contained the same macros and named ranges etc.

When I pasted the data, I accidently said "Yes" to the question - do you want the macro to point to the copy sheet.

I'm trying to get all macros to look at the master sheet and not go searching for the copy sheet when I run a macro, but I can't see in VBA where this instruction is held.

So, how do I reverse my silly mistake?

Nobby

 

[Nobby]

bump