I think you want the form to just be a spreadsheet. In
that case select the celss that you want to re-use for
data entry and choose, Format, Cells and on the protection
tab deselect the Locked checkmark and click OK
Now choose Tools, Protection and protect the worksheet.
You should be able to use the Tab key to jump between data
entry cells. Now save the workbook.
Remember that if you apply a password it is Case Sensitive
and you will be unable to use the worksheet if you forget
the password.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
