Hi Mike

to use Gord's code, you need to right mouse click on a sheet tab and choose
view code, now down the left of the VBE window you'll see your workbook's
name in bold & brackets and under that all the sheets listed and something
called "ThisWorkbook" (if you can't see this choose view / project explorer
from the menu)

double click on this workbook & then copy & paste Gord's code in the right
hand side of the screen. Then change
YourSheet
to the name of the sheet where you want to limit the number of columns &
rows that can be viewed.

once you've done that use ALT & F11 to switch back to your workbook ...
choose tools / macro / security and ensure your security settings are set to
medium - now save & close the workbook.

Now reopen it, say yes to enabling macros and then the code should run and
you should not be able to scroll outside of the specified range.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Mike" wrote in message
...
I have gone to VB and copied your code below but to no avail. Could you
explain again in perhpas simpler terms in case I've missed something ?
thanks

"Gord Dibben" wrote:

bek

Select all columns right of F and FormatColumnHide.

Same for rows below your data.

OR FormatCellsPatterns. Pick a nice gray color.

Alternative to the above........

Set the Scroll Area so's no one can move out of the area you designate.

Note: Setting ScrollArea is good for that session only and only the
activesheet. Has to be reset next time workbook is opened.

Best to place the code into a WorkBook_Open Sub in ThisWorkbook module
and
specify which worksheet.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:F50"
End Sub


Gord Dibben Excel MVP

On Wed, 2 Mar 2005 13:29:09 -0800, bekwud

wrote:

i have created a spreadsheet which only uses columns a-f. i would like
to
crop this area or remove g onwards so g onwards is completely blank or a
grey
area. any ideas? i can't find anything in the search for help database b
ut i
know it can be done as i have seen other workbooks the same. thanx for
your
time if you reply i appreciate it :O)