Precursor to VBA Macros

[Shackleton]

Apologies if something similar to this has been answered before.

At my work there is an excel file that we use most days that when it is opened automatically opens another workbook. However when I look at the VBA for the ThisWookbook object in VBA editor there is no code at all let alone anything triggered by the Workbook_Open event and there doesn't seem to be any code in any of the sheet objects or modules that would explain the file opening. I have asked around the department and the excel file is at least 20 years old and this makes me wonder whether there is some pre-VBA code (or at least code that doesn't display in the VBA editor) that is attached to the file. Would anyone be able to tell me whether my suspicion could be correct and if so is there is now any way to view and edit this code (I would like to stop the second file from opening as it has become largely redundant)?

Thanks,

 

[Shackleton]

I should have mentioned that the second excel file seems to contain macros that are stored in vertical columns of one of the sheets with each cell loosely corresponding to a line of code in VBA which adds to my thought that this is some form of VBA precursor.

 

[MARK858]

Sounds like an Excel4 macro sheet...

http://www.brighthub.com/computing/windows-platform/articles/84345.aspx
https://www.myonlinetraininghub.com/excel-4-macro-functions

 

[Shackleton]

Thank you Mark858,

Those were just the pointers I needed. Seems the auto open was accomplished through a defined name function.