#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Transfer data from Text Form Fields in MS Word into Excel? CWillis Excel Discussion (Misc queries) 1 July 18th 06 06:35 AM
Put form fields in Word forms into an Excel spreadsheet? AMG Excel Discussion (Misc queries) 4 May 15th 06 06:18 AM
Form Fields or Controls? David Cahill Excel Discussion (Misc queries) 1 May 14th 06 03:07 AM
Tabbing through form fields soma104 Excel Discussion (Misc queries) 0 May 11th 06 02:44 PM
Form Fields mcaalcorn Excel Discussion (Misc queries) 0 March 3rd 06 11:06 AM


All times are GMT +1. The time now is 07:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"