how to do a macro in excel step by step?

Question

i have excel 2007 home and student version and i am on windows vista. if i were to record a macro into the personal workbook so that i could bring it up in any excel workbook, what are the exact steps. the macro would be the name "my first macro" and i would like it to be called by pressing keys such as CNTL M, or something of your choice, just to get me starteed doing macros. If you would like to guide me in utilizing a button on my toolbar to call up a macro, that would even be better. but i would also require step by step on that. i once did a macro. i have the info on how to do it, but i've become dumbified or something in the macro process, it just hasn't been happening for me, and i don't know why, please help! note, when i tried a macro last night, the i went to run it, i got an error message stating that i must use "unhide". so i believe i am going in circles or something. ,

Answer 1

This might help you get going.

1. To create a macro in MS Excel, first export data into a new Excel file and have this file open but not formatted.

2. With the report data open in Excel, think about what commands or actions you would like to perform depending on the report.

3. Go to the main menu and choose "Tools | Macro | Record a Macro." The Record Macro dialog box will come up.

4. Give the macro a name, assign a shortcut key and store the macro in "Personal Macro Workbook." Hit the OK button to start recording commands. The shortcut key must be a letter.

5. Perform the commands within Excel to include in the macro.

6. Hit the Stop button to stop recording your macro.

7. You can now close the file and bring the data in again using the text file. This time (and for all other times), you can press the shortcut key to run the macro.

Note: Do not go into print preview mode, the macro will not work correctly if you do so.

Answer 2

once you're 18 then you definately've the final to settle on what you watch and once you watch it. it may be greater comprehensible in case you have been a splash infant, yet at 18 you're sufficiently old to make your person judgements approximately what you do. you would be able to desire to attempt being advantageous and asserting to her which you appreciate her place interior the enjoyed ones and her opinion, yet you're able to starting to be your person concepts up.