You did paste it into a standard code-module didn't you? (Not a sheet's code-module, and not the ThisWorkbook code-module.)



I don't understand 'jumped to a new module'





'cancelled'?! What does this mean?





There are 3 ways you can try to be sure that you're choosing the right macro in that dialgue box:
1. Choose This Workbook in the Macros in: field:


2. Close all workbooks except the one you're working on.
3. Rename the copied macro to say ResetMe then you'll be able to identify it for certain in that dialogue box.


(Who's Cal? He seems to just beat me to it each time, and yet I can't see any of his posts.)

understand 'jumped to a new module' - When I clicked Assign macro, a new module is opened where i was asked to enter the codes

'cancelled'?! What does this mean? - I deleted the automatic "private sub" codes in the new module above

Rename the copied macro to say ResetMe then you'll be able to identify it for certain in that dialogue box. - The ResetMe name did it. The ResetMe button is now running okay.

(Who's Cal? He seems to just beat me to it each time, and yet I can't see any of his posts.)[/quote] - I am so embarrassed by my assumption that I could shorten your username to Cal. I feel uncomfortable communicating to somebody without mentioning for once the name of the person I am having a conversation with. I'm very sorry if i overstepped the bounds by seemingly getting too personal with addressing you as Cal.

Don't take this too seriously.

Yeah, I know. Can i post a picture in this thread? I would like to post a picture of the core group of teachers from the public schools and mission-oriented teachers of an Anglican Church school who are being trained in the program that this forum helped create.