Ultimate Guide: VBA for Charts & Graphs in Excel (100+ examples)

VBA Code Snippets

Charts and graphs are one of the best features of Excel; they are very flexible and can be used to make some very advanced visualization. However, this flexibility means there are hundreds of different options. We can create exactly the visualization we want but it can be time-consuming to apply. When we want to apply those hundreds … Read more

How to remove Excel passwords with VBA (all 5 types)

There is nothing more frustrating than finding out a previous employee has used passwords to protect an Excel file, and it turns out nobody else knows the password. Or maybe it’s worse when it’s your file, your password and you’ve forgotten it. Either way… you’re stuffed! However, before you give in, let me share some ideas on how … Read more

How to fix “Microsoft has blocked macros” (2 simple ways)

You are probably here because you’ve seen a warning message: Microsoft has blocked macros from running because the source of this file is untrusted. This post provides the background to this message and the steps you should take to enable the file. During 2022, Microsoft introduced new security into the Windows version of Microsoft Excel … Read more

VBA Tables and ListObjects

VBA Code Snippets

Tables are one of the most powerful features of Excel.  Controlling them using VBA provides a way to automate that power, which generates a double benefit 🙂 Excel likes to store data within tables.  The basic structural rules, such as (a) headings must be unique (b) only one header row allowed, make tables compatible with … Read more