Make a "BLOCK Form" in Excel?

E

ED CABE

My really question is:

1.) How can I limit the user going to different cells/rows/column of the
form I create?

I just want them to go through only on specific cells to be filled-in.

Hope anyone could help me on this.

thank you so much.

[email protected]
[email protected]
 
J

JP

If you lock the worksheet cells, the end user will only be able to
edit the cells you specify.

1) Press Ctrl-A to select all the cells on the worksheet.
2) Press Ctrl-1 to open the Format Cells dialog box. Go to Protection
tab, fill in both checkboxes.
3) Now select ONLY those cells you want the user to be able to edit by
using Ctrl-click to make multiple selections.
4) Press Ctrl-1 to open the Format Cells dialog box. Go to Protection
tab, uncheck both checkboxes.
5) Go to Tools>Protection>Protect Sheet, click OK to enable.

At this point you probably want to highlight or border the cells, so
the users have visual aids for which cells are OK to edit.

--JP
 
E

ED CABE

Thanks a lot JP....it really works! You made me happy you know..

God Bless you always!

ED CABE =)
 
A

Andrew

Or Slightly more Advanced..
Right Click on The toolbars at the top.. Customize..
Next select the Commands tab.
Scroll down catagories list until you find Control Toolbox, click
on it.
Drag the Properties button up to one of your toolbars.

Now click on close.
Click the Properties button you have just created..
Now click on ScrollArea..
Type Something like B2:M10
it will change to $B$10:$M$10

Now that is the only place the person can move to.

Hope that helps.
Andrew

| My really question is:
|
| 1.) How can I limit the user going to different cells/rows/column
of the
| form I create?
|
| I just want them to go through only on specific cells to be
filled-in.
|
| Hope anyone could help me on this.
|
| thank you so much.
|
| [email protected]
| [email protected]
 
A

Andrew

#Note : This only works temporarily. When Workbook is re-opened it
needs to be re-set.
you can do this in VB..

Sub Workbook_Open()
Worksheets(1).ScrollArea = "a1:n25"
End Sub
A.

| Or Slightly more Advanced..
| Right Click on The toolbars at the top.. Customize..
| Next select the Commands tab.
| Scroll down catagories list until you find Control Toolbox, click
| on it.
| Drag the Properties button up to one of your toolbars.
|
| Now click on close.
| Click the Properties button you have just created..
| Now click on ScrollArea..
| Type Something like B2:M10
| it will change to $B$10:$M$10
|
| Now that is the only place the person can move to.
|
| Hope that helps.
| Andrew
|
| || My really question is:
||
|| 1.) How can I limit the user going to different cells/rows/column
| of the
|| form I create?
||
|| I just want them to go through only on specific cells to be
| filled-in.
||
|| Hope anyone could help me on this.
||
|| thank you so much.
||
|| [email protected]
|| [email protected]
|
|
 
Top