view problem

[ndmalam]

Hi
I have created a form in excell with some formulas .
Now I want to open it with only used colums and rows are visible.
No menus should be seen.
is istpossible
I have four colums and ten rows used. when I click on the last row o
colum cursor goes to next blank cell. I want it not to go off the form
and cusur should remain within those used cells.
best regards
ndmala

 

[Earl Kiosterud]

ndmalam,

You can allow only certain cells to be selected: Select only the cells the
user should be able to select, then unlock them (Format - Cells -
Protection). Protect the sheet (Tools - Protection - Protect sheet).
Enable selection for only those cells (you'll probably want to do this in
Workbook_Open):

Worksheets("Leads").EnableSelection = xlUnlockedCells

And you can hide all the rows and columns beyond your cells. Then there
will be just gray beyond your used cells. To do so, select the first column
beyond your used cells (click the column header), then all the columns to
the right (Ctrl Shift RightArrow), then right click any selected column
heading and choose "Hide." Do the same for the extra rows.

You can set the scroll area This will limit the range in which the user
can scroll. It will keep them from scrolling out and getting hopelessly
lost in the gray area above, or in unused cells if you didn't hide them as
above. You'll probably want to do this in the Workbook_Open event macro:

Worksheets("Leads").ScrollArea = "$A:$I"