Make a "BLOCK Form" in Excel?

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

(e-mail address removed)
(e-mail address removed)

 

[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

 

[ED CABE]

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

God Bless you always!

ED CABE =)

 

[JP]

Glad to hear it!

--JP

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

God Bless you always!

ED CABE =)