| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
when you protect a sheet, you can't enter using a form
I have a worksheet with formulas. I have locked the appropriate fields that
I do not want users to mess with and unlocked the fields they can mess with.....and then I protected the sheet. I wanted the user to enter data using a simple form (from the Data menu)......but it's not letting me. Is there a way around this? Or do I have to use the "vba form" stuff which I'm not having a lot of luck with? Thanks, in advance, for any helpful suggestions! Paula |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Protect Workbook Vs Protect Sheet | New Users to Excel | |||
| Baffling! Spreadsheet Data Form Size | Excel Discussion (Misc queries) | |||
| Excel 2002 "Protect Sheet", but allow "Hide Columns"? | Excel Worksheet Functions | |||
| when I protect my sheet enter tab, & arrow keys dont work... | Excel Discussion (Misc queries) | |||
Threaded Mode
