Baapi,

Your Auto_Open and Auto_Close subs should work if they're located in a
standard module. Note that these are replacements for Workbook_Open and
Workbook_BeforeClose events, of which neither of these events should exist if
using the Auto_ run macros.

HTH
Garry