It is important to remember that macro-enabled workbooks can hide nasty viruses that can seriously damage your computer files. When receiving a workbook that is macro-enabled off another person (either via email or the Internet) your first consideration should always be security. The security settings in Excel will allow you to open and edit the workbook, but the macros will NOT work.[/font] There are 4 levels of security that can be set to prevent any damage from infected files: Disable all macros without notification: All macros in the workbook will be disabled upon receipt and you will not be made aware … [Read more...]
Introducing Macros in Excel 2007
When working with Microsoft Excel, you may find yourself repeating the same calculations or typing the same text in multiple cells. A 'macro' simply refers to a very useful and labor saving function within Excel that will store the action (or text) and make it available to you whenever you need it to use it. Running your chosen macro will then cause Excel to complete the process for you automatically. Follow the steps below and you may be able to save yourself a lot of time and effort! Step 1 - Display your Developer Tab Macro tools are available through your Developer Tab and you have to set this up to be … [Read more...]
Microsoft Excel 2007: Useful Macro Information
This tutorial deals with some useful features and shortcuts that Excel has to offer when using macros within your work. By the end you will be fully proficient in creating a shortcut key, along with assigning and deleting a button for a macro. Create a macro shortcut key: . Click the Developer Tab found in the Ribbon . Click into the Code Group - Macros button . The Macro dialogue box will then be displayed and you will see a full list of all your macros . Choose the relevant one from the list and click the button marked Options . This will display the Macro Options Dialogue Box . Have a look at the … [Read more...]
Microsoft Excel 2007: How to Edit/Delete Macros and Save Your Macro Enabled Workbook
If you make a mistake when recording a simple macro, the easiest thing to do is delete the macro and start again, but it is also possible to edit the function of a macro using the Microsoft Visual Basic Editor. This tutorial will explain how simple changes can be made to macros that require little or no understanding of Visual Basic Editor. More complex editing requires an in-depth understanding and so will not be explained here. The special actions that must be performed in order to save a macro-enabled workbook correctly will also be outlined. To edit a macro: . Click the Developer Tab within the Ribbon … [Read more...]