Assigning Macro to an Icon

Assigning Macro to an Icon  “Assigning Macro to an Icon” on the toolbar in Excel. Watch our quick video to see how easy it is to do. We can assign a macro to an icon on the toolbar or shortcut toolbar – making it easy to find no matter what sheet your are...

Creating a custom Tab and adding icons to the Ribbon

Creating a Custom Tab and adding Icons to the Ribbon This quick video explains how to you can go about Creating a Custom Tab and also how to add Icons to the Ribbon. Excel allows us to add our own Custom ribbon – like the eLearnExcel ribbon and we can add our own...

Generalising Macros to prompt for a file

Generalising Macros to Prompt for a File Often when we record a Macro we find that it will work for a week or a month or a particular file – but we have to re-record it in order to make it work for another file or time period. In order to make a macro more useful – we...

Excel VBA Common Question: What is ‘Option Explicit’ for?

Excel VBA Common Question: What is ‘Option Explicit’ for? What is Option Explicit for? From time to time I thought I would post answers to the most common questions I get asked during the classroom based courses that we run. We will also do this for the online Excel...

Recording a simple macro to save yourself repetitive work.

Recording a Simple Macro to save yourself Repetitive Work The whole area of macros in Excel can be an intimidating area to start with but some things can be very straightforward. I thought it would be useful to publish some useful tips on our blog to give you a taste...