Philip Treacy, Author at My Online Training Hub • Page 5 of 5

November 19, 2014

Workbook & Worksheet Events in Excel VBA

What Are Events? An Event occurs when certain actions are performed by the user or VBA. For example when you

September 23, 2014

Change the Color of Words in Text

One of our students (hi Leah 🙂 ) sent me a question last week asking how she could change the

June 18, 2014

Protect and Unprotect All Sheets in a Workbook

I recently had a client who has a requirement to protect and unprotect a lot of sheets. This was something

June 18, 2014

Customize the Ribbon in Excel

You can customize the Ribbon in Excel so that you add your own tabs and icons to run commonly used

May 20, 2014

Create Hyperlinked List of Files in Subfolders

I wrote a macro a few weeks ago which created a list of files with hyperlinks to those files, but

April 16, 2014

Create Hyperlinked List of Files in a Folder Using VBA

So you have a load of PDF's, or scanned documents, or some nice pictures of your stamp collection*, and you

April 9, 2014

Macro Enabled Excel Templates

What You Can Do With Macro Enabled Templates This is up to you. Using a template allows you to design

April 9, 2014

Trusted Locations

If you want Excel to stop asking you if you want to enable macros every time you open a macro

April 1, 2014

Create a Personal Macro Workbook PERSONAL.XLSB

When you create a macro in Excel, by default, the macro works only in the workbook that contains it. But

February 27, 2014

Create Barcodes With (Or Without) Excel VBA

Barcode Types & Uses There are LOTS of barcode types used for a multitude of things. Various internationally recognised standards

February 7, 2014

Convert Numbers (Currency) to Words With Excel VBA

We get requests now and again asking how to convert numbers to words (or convert currency) e.g. 123.45 becomes One

December 11, 2013

Assign a Macro to a Shape or Use a Shortcut Sequence

So you’ve got some code and you want to be able to run it, but opening up the list of

November 27, 2013

How To Use VBA Code From The Internet

So you’ve found some VBA code on the ‘net that will save you hours and hours of work, but how

November 27, 2013

How To Enable the Developer Tab in Excel

The Developer tab in Excel gives you access to features and tools that help you to write and run macros.

October 14, 2013

VBA to Create PDF from Excel Worksheet Then Email It With Outlook

Real World Scenario One of my customers (thanks Tony) creates invoices in Excel for his clients and at the end

October 1, 2013

Merge Excel Worksheets with VBA

The Scenario Let’s say that you have a lot of sheets in your workbook and you want to merge all

September 11, 2013

Finding Missing Numbers in a Range Using VBA

The Problem You have a sequence of numbers, and you want to find the numbers that are missing from that