You can check if a workbook contains macros by going to the 'Developer' tab on the ribbon and clicking the 'Visual Basic' button. If there are macros in the workbook, they will be displayed in the editor window. You can also check the file extension of the workbook - if it ends in '.xlsm' instead of '.xlsx' it likely contains macros.