You might be asking yourself, "Why did Microsoft make all these changes to macros when they have been relatively unchanged for quite some time?" Good question. The short answer is for Disabled mode. To make applications relatively functional without running code, these changes were required to macros. These combined features make macros more viable than in previous versions, and the templates in Access were designed with Disabled mode in mind. As mentioned in Chapter 1, most of the new templates run using safe macro actions and without code.
Does that mean that you shouldn't use VBA for your solutions? Of course not! But it does mean that in certain scenarios such as where you might not want code to run, or you are looking for simple lightweight solutions, macros might provide a reasonable alternative.
Was this article helpful?