Macro-enabled workbook (.xlsm vs .xlsx)

[craigexcel]

I have received a workbook from my Corporate office that was received as a macro-enabled file (.xlsm). While I'm basically familiar with finding and editing VB code in a module, I don't see any code in a module in this workbook. Yet, when I attempted to save the workbook as .xlsx, I was prompted that a workbook with the "VB project" feature in it, could not be saved as a macro-free workbook (.xlsx). What VB content is in this workbook that requires it to be saved as .xlsm? Can you offer an explanation or point me to some online content that elaborates on what causes this? Thanks.

I'm using Excel 2007.

 

[VoG]

Right click each tab and select View Code.

Press ALT + F11, in the Project window double click ThisWorkbook and look for code.

 

[craigexcel]

VoG,
Thanks for your insight. So taking your suggestion, I found the following code 'attached to' (if that's the correct terminology) several of the worksheets. This appears to be useless / incomplete code. Could this code be deleted without any ill effect? Or, does this code actually do something?

Private Sub Worksheet_Activate()

End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

 

[VoG]

You can just delete those: they are not doing anything (apart from messing up your save)

 

[craigexcel]

That's what I thought. Must be some leftover code from an attempt at incorporating some VB in the workbook, which was never deleted. Thanks, VoG.