Make a "BLOCK Form" in Excel?
 

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.

Make a "BLOCK Form" in Excel?
 

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 ToolsProtectionProtect 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

On Nov 26, 7:05 am, ED CABE <ED wrote:
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.

Make a "BLOCK Form" in Excel?
 

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

God Bless you always!

ED CABE =)

"JP" wrote:

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 ToolsProtectionProtect 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

On Nov 26, 7:05 am, ED CABE <ED wrote:
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.

Make a "BLOCK Form" in Excel?
 

Glad to hear it!

--JP


On Nov 26, 9:44 am, ED CABE wrote:
Thanks a lot JP....it really works! You made me happy you know..

God Bless you always!

ED CABE =)

"JP" wrote:
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 ToolsProtectionProtect 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.

Make a "BLOCK Form" in Excel?
 

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

"ED CABE" <ED wrote in message
...
| 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.
|
|
|

Make a "BLOCK Form" in Excel?
 

#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.

"Andrew" wrote in message
...
| 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
|
| "ED CABE" <ED wrote in message
| ...
|| 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.
||
||
||
|
|