ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Form Fields (https://www.excelbanter.com/excel-discussion-misc-queries/119532-form-fields.html)

Anna

Form Fields
 
I am trying to create a form with form fields in Excel 02. I have word docs
that have form fields, (boxes that are a color that you can click on and
insert info). I need to add these form fields so that you can easily tab thru
and insert info.

Tim Sheldrick

Form Fields
 
You could use worksheet protection. Highlight the modifiable fields and
format them to not be locked (Protection Tab), then protect the entire sheet
using Tools/Protection, selecting that users cannot select locked fields.

Hope this helps.

"anna" wrote:

I am trying to create a form with form fields in Excel 02. I have word docs
that have form fields, (boxes that are a color that you can click on and
insert info). I need to add these form fields so that you can easily tab thru
and insert info.



All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com