| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected Excel Worksheet
I have an Excel worksheet that contains questions, the cells with the
questions have been protected to prevent users from changing the questions. The users are to type the answer in the cell beside the question (I.E. question in protected cell A1 answer goes in unprotected cell A2). However, if a user copies the answer from another document and pastes the answer into cell A2 the information is then protected and does allow them to change the answer that was pasted into cell A2. Can someone explain why this is happening? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel; tabbing through protected worksheet | Excel Discussion (Misc queries) | |||
| Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
| How can I do a "Save As" on a protected excel worksheet | Excel Worksheet Functions | |||
| spell check for protected worksheet for Excel 97 | Excel Discussion (Misc queries) | |||
| How do i delete a row in a excel worksheet that is protected | Excel Worksheet Functions | |||
Threaded Mode
