|Home - Contact Us - Courses - Learn online free - Assessment - Manuals - Sitemap - Articles - Company profile - Newsletters - Tips|
Macro’s work very nice when you want to make your spreadsheets more interactive. It makes spreadsheets more attractive and more user friendly. The concept is to insert something (a button or something else) and put a macro on it, to do something when clicked or ticked.
Macro Toolbar and security settings
Before working with macro’s you must insert the developer’s toolbar. Click on the excel button and then on Excel options.
Tick the “Show developer tab in ribbon” box.
In excel 2010, you have to go the customize option and tick it from there.
For this example we are going to insert a “menu” with one button. When this button is clicked a specific sheet will be shown.
Step 1: Open a new excel file
Step 6: Your mouse cursor changes to a star
Step 8: Excel will automatically give a name to the macro. Click on “record” and on the next screen click “ok”
Step 11: To have the best effect we must put the same button in the test sheet to hide it. So when standing in the test sheet, insert a button again and record a new macro. But this time hide the “test” sheet and click anywhere on the menu sheet. Stop the recording of the macro again.
Now you will have an interactive file with a menu, to hide and unhide sheets. You can make the menu very nice now, with more than one button
The other way of using macros is by making amounts interactive. For example, instead of making the user insert 20%, you can put a scrolling bar next to the cell with arrows, to change the percentage.
Step 1: Open a new file
Step 4: The button must be linked to a cell. So put in any cell in the “cell link”.
This function makes your spreadsheet look very professional.
<-----Back to index
|Home | Testimonials | Terms & Conditions | Contact Us | Courses | Manuals | Sitemap | Articles ||