moving between unlocked cells using Enter, setting restrictions to cell size in template.. and some

[littleme]

Hello!

My boss is breathing down my neck to create some forms for the office
and Im desperate for help.

Ive created a template and locked, unlocked and protected the
worksheet. So far so good. The problem is though that as the form is
to be filled in on line and it would be best if the user could use
Enter to skip between unlocked cells (the ones they're meant to fill
in), skipping the locked cells completely. I know this works fine with
Tab but since it doesnt come naturally for most people to end typing
by pressing Tab (and these people really arent the best at typing)
would be really good. Would save a lot of time, instead of getting and
error message and having to click that away and so on.....

Secondly, I would like to restrict the size of the cell. Know can be
done by limiting the verifying and the setting text length, but it
doesnt really work that well. Wondering if its possible to "lock" cell
height and width and yet make it possible to fill it in. Would like
and error message (with a little sound since people here tend to not
look at the screen when they type) to appear immediately when text
length/ cell size had been exceeded instead of after press Enter or
Tab....

Lastly, need the form to be write protected. where do i find that?

would be very grateful for help. otherwise its back to making coffee
and the mail for me....

 

[Bob Greenblatt]

Well, we sure don't want you to go back to making coffee (unless it's really
really good.)

So, check the Excel preferences for Edit. If the check box "Move selection
after RETURN" is checked, pressing return will move to the next unprotected
cell.

Unfortunately, you will not be able to do this with Excel in a cell. Not
even with a macro. However, you CAN do it with a user form under macro
control. You may want to consider collecting the data this way.

You can write protect the form with the Save-As option. Select read only
recommended.

Check back here if you're still in danger of delivering the mail. I'm sure
we can help.