Hello Excellers and welcome to another #MacroMonday #Excel blog post in my 2020 Excel and macro series. Today let's look at removing your Personal Macro Workbook from Excel. This workbook will...
Tag: Macros
Macro Mondays – Convert A Range OF Cells To ‘Proper’ Case With An Excel Macro
Hi Excellers, and welcome back to another #MacroMonday #Excel blog post in my 2020 macro series. It is time to sit up. We will be using the Proper Function today!. You may (or may not) know...
Macro Mondays – How To Run An Excel Macro Automatically When You Open Your Excel Workbook
Hello Excellers and welcome back to another #MacroMonday #Excel blog post in my 2020 series. So, today I will show you a number of different ways to automatically run a VBA macro when you open...
Macro Mondays – A Simple Macro To Refresh All Data Connections When Opening An Excel Workbook
Happy Monday!, and it is Macro Time. Welcome to another #MacroMonday #Excel blog posts in my 2020 series. Today we will write a simple macro to refresh all data connections when your Excel...
Hello Excellers and welcome back to another #Excel #FormulaFriday blog post in my 2020 Excel series. Today I will show you how to conditionally format an Excel worksheet tab. This is useful if...
Count The Number Of Times A Workbook Has Been Opened. Macro Solution.
Hello Excellers, welcome back to another #Excel #MacroMonday blog post in my 2020 all things Macro series. Do you need to know how many times a workbook has been opened?. Would you like to know...