Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected worksheet allow users
Hello - we have Excel 2003 (SP3). We need users to be able to sort the cells
so when protecting the sheet we check sort under "Allow all users of this worksheet to:" but Excel doesn't allow them to do anything to the sheet. The users get the following error: "The cell or chart you are trying to change is protected and therefore read-only. To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Tools menu, Protection submenu). You may be prompted for a password." Any ideas? Thanks in advance for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected worksheet allow users
Hi teelius
Turn on autofilter first and then protect the sheet with the option checked -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "teelius" wrote in message ... Hello - we have Excel 2003 (SP3). We need users to be able to sort the cells so when protecting the sheet we check sort under "Allow all users of this worksheet to:" but Excel doesn't allow them to do anything to the sheet. The users get the following error: "The cell or chart you are trying to change is protected and therefore read-only. To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Tools menu, Protection submenu). You may be prompted for a password." Any ideas? Thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I allow users to edit links in a protected worksheet? | Excel Worksheet Functions | |||
Allow formula auditing for users in a protected worksheet? | Excel Discussion (Misc queries) | |||
how can I allow users to open groups in a protected worksheet? | Excel Discussion (Misc queries) | |||
How to let users add lines in lists in protected worksheets? | Excel Discussion (Misc queries) | |||
In a protected worksheet allow users to delete rows | Excel Worksheet Functions |