Excel Macros Function-Creating-Saving-Sharing
The primary function of Excel macros is to reduce time for those who spend a lot of time using Excel. These macros automate frequent or repeated actions. The latest version of Excel has several pre-loaded macros, but the most useful are those that are user-generated using Excel's unique macro-recording function.
To create a macro, simply go to the "Tools" menu, and select the "Macros" sub-menu. From here, click on the "Record New Macro" option. Form here a "Record Macro" pop up will appear, asking you to name your macro. You will also need to set a keyboard shortcut and choose a location to save it. Once you have entered all your information, click "OK" and a new little pop-up will appear. This is the recording module, which allows you to pause, stop and resume recording.
It is very important that you keep your macros saved in a place that you will remember; otherwise you will not be able to access or edit them at a later date. Although there is a default "My Macros" folder, if you use many different macros, then it is best to set up several macro folders by usage.
One of the best features of Excel macros is the ability to share them between computers. If you are working on a networked computer, simply enabling all macros on your computer will give you access to others' created macros. However, if you want to send a macro to someone, you can share it by uploading it to a server or attaching it to an email. As long as the recipient has a compatible version of Excel, she can save it to a designated macro folder and use it any time she likes.
Creating a Toolbar Icon