Did you make resave your workbook under a new file name? And/Or do you have
another workbook open (maybe the one you copied from) that has macros with
the same name? Check in particular your personal workbook, personal.xls.
Look in the Project Explorer under all the projects listed for a sub with the
same name. Also look at the list that comes up in the Macros menu - if it
has a workbook name before it, like Book2!MyMacro, that shows which book
contains the code that is running.
--
- K Dales


"alainr" wrote:

Excel does not seem to be using the version of a macro that is attached to
the worksheet module. Any changes I make to the module (breakpoints, code
change, etc...) at not reflected when I call the macro (either from the VBA
interface or from Excel worksheet push-button or from Macro menu). I tried
to open and close Excel, and still... I can't make a change to my macro.

Is it possible that there is a cached version of my old VBA module hidden
somewhere??

What is going on?