Hello fellow Excellers, I hope you are well and thanks for joining me on another macro Monday blog post. I want to share with you today how to protect and or hide your Macros from prying eyes. ...
Category: Blog
Hello Excellers. I have decided to go Back To Basics today for today's #formulafriday blog post and take a look at relative and absolute references in Excel. Why would I do that?. Well, a...
Macro Monday – Create An Excel Function To Extract Hyperlink Addresses
Hi Excellers. Would you like to know how to create your very own Excel function that extracts hyperlink addresses? If so, then read on. In this blog post, we will show you how to create such a...
Your Data Is In Access But You Need To Create An Excel Report – Create An External Data Connection
If you have data stored outside of Excel, such as an Access Database, SQL Server or and OLAP Cube then you can still use a Pivot Table to analyse this data, yes all you need to do is connect to this...
Formula Friday – Do You Want A FAST and FUN Way To Learn Excel Formulas?
Excel formulas can be daunting, I know that - even if you have been been using excel for years, the formula part can be scary. The many text books on offer or courses really do get complicated...
Macro Mondays – How To Display One Excel VBA Procedure At A Time
Hello Excellers and in today's #macromondays blog post, let's look at something a little different that may help you if you have multiple procedures or macros in the one Module. Normally your code...