| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Field and Worksheet Restrictions
I have a multiple tab document that I would like to give access to the users to enter text in some places and number in other fields throughout the entire document, seperate tabs. The second thing I would like to do is restrict the entering of data in any other part of the document. That means that only the fields that I would like them to into enter data into is available for manipulation. -- alvarezrrb ------------------------------------------------------------------------ alvarezrrb's Profile: http://www.excelforum.com/member.php...o&userid=35075 View this thread: http://www.excelforum.com/showthread...hreadid=548260 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Field and Worksheet Restrictions
Hi alvarezrrb,
Use Format|Cells|Protection and unlock the cells you want to be able to enter data into, then use Tools|Protection|Protect Sheet or Protect Workbook to apply the level of protection you want - the options are explained in Excel's help file, under 'Protect workbooks and worksheets from changes'. Cheers -- macropod [MVP - Microsoft Word] "alvarezrrb" wrote in message ... I have a multiple tab document that I would like to give access to the users to enter text in some places and number in other fields throughout the entire document, seperate tabs. The second thing I would like to do is restrict the entering of data in any other part of the document. That means that only the fields that I would like them to into enter data into is available for manipulation. -- alvarezrrb ------------------------------------------------------------------------ alvarezrrb's Profile: http://www.excelforum.com/member.php...o&userid=35075 View this thread: http://www.excelforum.com/showthread...hreadid=548260 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Field and Worksheet Restrictions
Depending on you version of excel, you can select TOOLS PROTECTION ALLOW USERS TO EDIT RANGES Then select the ranges and then you will see a button that says PROTECT SHEET Then select the options and click ok all done. -- Zygan ------------------------------------------------------------------------ Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423 View this thread: http://www.excelforum.com/showthread...hreadid=548260 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use the data in a named field to select a worksheet tab . | Excel Discussion (Misc queries) | |||
| can i insert the name of the worksheet into a field? | Excel Discussion (Misc queries) | |||
| Field , Date range and Sum from worksheet import | New Users to Excel | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| worksheet | Excel Worksheet Functions | |||
Linear Mode
