Quote:
Originally Posted by macropod
To add the macro to your workbook's 'main' sheet code module, press Alt-F11 to start the VB Editor, double-click on the 'Sheet1(main)' entry on the left, then paste the code from my post into it. Oh, and fix up the spelling errors (e.g. 'Customer A', not 'cutomaer A')!
PS: Please don't quote the entire post responded to in your replies; if something needs to be quoted, quote only that part.
|
1. I have renamed the sheet Customer A.
2. Thanks for the opinion, i would now quote only important things.
Now since i am doing this for the first time, this easy job looks a bit hard for me
here is what i did>>>>>>
I copied your code, and in my workbook perss alt+ F11(it opened VB editor) i dubble click on sheet one(main) and paste your code there .
after that i go to "file" Tab and choose> "Close and return to Microsoft Excel"(alt+Q)
i dont see any changes in my workbook.nor i see any saved micro to run
what to do now?
i know i am not doing it in a right way.please help me