Quote:
Originally Posted by Marcia
Hi there.. I copied the enhanced macro that Cal posted for the SF2 into my own workbook.
|
You did paste it into a standard code-module didn't you? (Not a sheet's code-module, and not the ThisWorkbook code-module.)
Quote:
Originally Posted by Marcia
I tried creating a quick button for "reset" by inserting a shape >> assign macro>> then selected reset in the macro list but it jumped to a new module instead of the module in which I pasted the codes.
|
I don't understand 'jumped to a new module'
Quote:
Originally Posted by Marcia
I cancelled the new module,
|
'cancelled'?! What does this mean?
Quote:
Originally Posted by Marcia
How do I create a button from the "reset codes" of my own sheet?
|
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.)