How do I limit the visible rows in Excel?

I want to hide everything in a worksheet except for the table into which I am
asking others for input. Columns are easy, but how can I hide ALL the rows
below my chart? I could colour them out in black, that would lead to
printing issues.

Help please!

Tom,

One way I like to restrict access is by defining a scroll area thus:

Sub DefineScrollArea()
ActiveSheet.ScrollArea = "MyCellRange"
End Sub

Once you run this macro, you can only move the cursor to a cell within this
range.
You can also use cell addressses instead of the "MyCellrange" range name

Sub DefineScrollArea()
ActiveSheet.ScrollArea = "B5:G25"
End Sub

To turn this function off, use a macro like this:

Sub ResetScrollArea()
Worksheets("Database").ScrollArea = ""
End Sub

To hide the contents of worksheet cells, select them, then go into Format
Cells Number Custom and enter ;;; (three semicolons) in the type box.

This will hide everything in the delected cells without you having to change
the colours. To reset this, reset the cell format to general, or something
like that.

You can also hide rows by selecting them the clicking Format Rows Hide.

Hope this helps

Pete





"tomcheesewright" wrote:

> I want to hide everything in a worksheet except for the table into which I am
> asking others for input. Columns are easy, but how can I hide ALL the rows
> below my chart? I could colour them out in black, that would lead to
> printing issues.
>
> Help please!

set the print area file>printarea>set print area to incluse only your chart
and on the screen select your table then on the std toolbar click on the zoom
box and select "selection".If you want to hide data highlight the rows you
want to hide on the very left margin >right click>hide
--
paul
remove nospam for email addy!



"tomcheesewright" wrote:

> I want to hide everything in a worksheet except for the table into which I am
> asking others for input. Columns are easy, but how can I hide ALL the rows
> below my chart? I could colour them out in black, that would lead to
> printing issues.
>
> Help please!

select the row below the last row that you want visible. hit ctrl+shift+arrow down.
Right click and select hide.

Hi Pete,

The macro only works during current session, and the next time the file is open, the preset scroll area is no longer valid even the file was saved before that.

What codes should be added so that the macro is auto run when the file is open, and the defined scroll area is maintain.

Thanks


Taych

Hi all,
I would just go into the properties on the VB page and change the scroll area to your desired range. HTH.

Greg.

Hi Tom,

To hide rows do the following
1) Click the first row number you want to hide, this will select the whole row
2) Press Ctrl+Shift+the down arrow key, this will select ALL the rows below.
3) Select 'Format' on the Menu toolbar and choose 'Row', then select 'Hide'

All the selected rows will now be hidden and a grey moat will appear.

Hope this helps

"tomcheesewright" wrote:

> I want to hide everything in a worksheet except for the table into which I am
> asking others for input. Columns are easy, but how can I hide ALL the rows
> below my chart? I could colour them out in black, that would lead to
> printing issues.
>
> Help please!