The macro could be on a hidden sheet, or could be used in a named formula.
To check for the former, open the VBE and see if there are any sheets that don't show up with tabs in the workbook (Hidden or VeryHidden).
For the latter, do Insert > Name > Define, and look at all the names.
Bookmarks