Hi Chersie,

Without a much more intimate knowledge
of your workbook, it is difficult to be
categoric about the size of your workbook;
at its most benign, the size could simply be
a legitimate reflection of  sheer volume of
data,

That said there are various general areas
which may be addressed:

(1)  Reduce the size of each of the 32
      worksheets to the real data area. In this
      connection, see Debra Dalgleish's
      suggestions on restiing the Used Range
       at:

       http://www.contextures.com/xlfaqApp.html#Unused

(2) Consider if 32 sheets really are necessary.
     If, as potentially suggested by another
     thread, the first sheet represents a master
     database and the remaining sheets display
     subordinate detail, perhaps you might
     consider:

           - deleting the detail sheets and using
             the Excel's AutoFilter, Advanced
             Filter or Pivot  Table tools to provide
             the reuired report information.

             If you are not familiar with these tools,
             see Debra Dalglesh at:

            Excel -- Filters -- AutoFilter Basics
            http://www.contextures.com/xlautofilter01.html

            Excel -- Filters -- Advanced Filters -- Introduction
            http://www.contextures.com/xladvfilter01.html

            Using Pivot Tables in Excel
            http://www.peltiertech.com/Excel/Pivots/pivottables.htm

 (3)  If the 14 macro buttoms on each of
        the 32 sheets perfom analagous operations,
        consider replacing the 32 x 14 buttons with
        a customised toolbar with a single set of
        buttons, possibly adapting the button code
        to operate on any of the sheets of interest.

However, the relevance of the above
suggestions will depend on your data and
your particular requirements; the suggestions
are, therefore, to be regarded as points for
consideration.

---
Regards.
Norman

Also, hard to say without seeing your workbook.(send to my address below if
desired)
If you must have 32 sheets why not just use a double_click event to double
click on the cell to do whatever is desired from there.