Take note

The built-in macros Auto_Open, Auto_Close, etc., have been replaced by event procedures (see Chapter 10) in Excel 97 and above, but they are still supported for compatibility with workbooks created in previous versions. It is recommended that you do not to use the Auto_Open and Auto_Close macros in new workbooks. For even though they do what is required, implementing event procedures is more appropriate now (see Chapter 10). They have been included here for two reasons. If you are developing a workbook that will make use of versions of Excel before 97, you must use the Auto_Open and Auto_Close macros. Moreover, you might still see them being used by other programmers.

0 0

Post a comment