You could set a scroll area so you cant work outside the first 100 lines.
Worksheets(1).ScrollArea = "A1:Z100"
use as a workbook open event.

"Shane Devenshire" wrote:

Hi,

You can select row number 101 and press Shift+Ctrl+Down Arrow, then right
click any of the selected row numbers and choose Hide. You really aren't
making the page only have 100 lines but it behaves that way.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"j5b9721" wrote:

is it possable to make a excel page only 100 lines??? How would it be done
using excel pro 2000?