"Andy" wrote in message
...
We have a spreadsheet which limits the available cells you can enter
values
into - basically A1 to N40. If you show column headers these are not shown
either for rows/columns outside that range.
I wish to know where this is set so that I can do it on other sheets, but
do
not know how.
Does anyone have any ideas?

Hi Andy,

The only way I'm aware of to not display row and column headers beyond a
certain area is to hide all rows below that area and hide all columns to the
right of that area. Select them all and choose Format/Row/Hide and
Format/Column/Hide from the menu.

You can limit the area that the user has access to without hiding all
those rows and columns by adding the a startup macro similar to the
following to your workbook, changing the name of the worksheet as
appropriate.

Sub Auto_Open()
Sheet1.ScrollArea = "$A$1:$N$40"
End Sub

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *