If you are in the VBEditor and double click on on all object or modules in the Project Explorer, that should open windows where you can look for the code you seek.
From your description, it should be in the code module associated with the sheet in question or in ThisWorkbook.