Much of the functionality is likely to be well past its usefulness and probably only relevant to the versions of Excel in which it is supported. These Macros are triggered using standard spreadsheet functionality, so may be a better option in some circumstances, especially when considering the final users of a spreadsheet. If you already know how to use VBA, this question becomes harder to answer. The main benefit is performing actions without knowing VBA code which is not available using normal spreadsheet functionality.
You may be wondering why you would want to use Excel 4 Macros. Click the image below to download the PDF.ĭownload Excel 4 Macros PDF Why use Excel 4 Macros? Phil has kindly agreed that I can share the PDF with the readers of Excel Off The Grid. In November 2017 Phil Treacy from issued a 653 page PDF (no, that’s not a typo, it really is 653 pages long) with a comprehensive list of Excel 4 macros.
There are some sites with examples of Excel 4 Macros, but I couldn’t find anything complete. The help file documentation is still available, however it no longer compatible with current versions of Windows. These types of Macros were superseded when VBA was introduced in Excel version 5, hence why any macros before that are referred to as Excel 4 Macros.Įxcel 4 Macros still work today, but there is little information about them. This post used an Excel 4 Macro as a possible option for turning a string into a formula. At the start of this year, I wrote a post entitled Turn a string into a formula with EVALUATE.
0 kommentar(er)
