That works--thanks--but seems like excell would have that function built in
some where

"Gord Dibben" wrote:

Kevin

You cannot do away with the unused cells. A worksheet has 256 columns and
65536 rows.

You can hide the rows and columns you don't want to see as Jack suggests.
Select them and FormatHide.

Alternative.........You may want to try setting the Scroll Area.

This setting will not remain after closing the file.
Place a code line in the Workbook open event to set it
each time when you open the workbook.

Right-click on the Excel Logo left of your "File" on menu. Select "View Code"
and paste the following in there. Save the workbook and close/re-open to see
the scrollarea fixed to the range A1:H40

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "A1:H40"
End Sub

Adjust to your sheetname and range.

Gord Dibben Excel MVP

On Wed, 29 Sep 2004 07:31:09 -0700, "Kevin"
wrote:

I have a sheet that has buttons on for running macros. How do I just have the
area of worksheet visable so people cannot scroll across or down. I don't
wan't to freeze panes, I would like to do away with the unused cells
altogether?