VBA code already there in brand new file

[lezawang]

Hi
I closed all excel files. I opened a new one by clicking on excel icon. I go to VBA editor and I see some codes there? Why and from where they came? Thank you very much.

 

[JoeMo]

Perhaps you have add-ins and/or a Personal.xlsb workbook that contains macros.

 

[Peter_SSs]

Is the code actually in the workbook that is automatically opened when you open Excel, or as JoeMo has suggested?

If the code is in the standard workbook that is opened with Excel, then perhaps you have a workbook with VBA code in your Excel 'Startup folder'. See https://support.office.com/en-us/article/customize-how-excel-starts-6509b9af-2cc8-4fb6-9ef5-cf5f1d292c19

 

[ZVI]

Or may be it's just Option Explicit code line there.
If so then you can ignore that as it does not saved with XLSX, such a behavior can be disabled in VBE - Tools - Options - Editor - Require Variable Declaration, but it is useful for coding.

 

[alansidman]

Or when you open the VBE, is the Funcres file showing codes.

 

[lezawang]

Thank you all. I appreciate the help

Or when you open the VBE, is the Funcres file showing codes.

Or when you open the VBE, is the Funcres file showing codes.

Or may be it's just Option Explicit code line there.
If so then you can ignore that as it does not saved with XLSX, such a behavior can be disabled in VBE - Tools - Options - Editor - Require Variable Declaration, but it is useful for coding.

Is the code actually in the workbook that is automatically opened when you open Excel, or as JoeMo has suggested?

If the code is in the standard workbook that is opened with Excel, then perhaps you have a workbook with VBA code in your Excel 'Startup folder'. See Customize how Excel starts