Hello,
Select TOOLS-->MACRO-->VISUAL BASI EDITOR
In this VB window select VIEW-->PROJECT EXPLORER
A window will appear (or is already open) and should have your spreadsheet name in their, as well as all the sheets, after the last sheet there is a THIS WORKBOOK, Right Clisk the Mouse when over this and select VIEW CODE
Past the code in the large window, above should be two drop down boxes saying (General) and (Declarations)
Is this expalined well enough?