Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
protection / edit ranges
Excel 2002
I created a workbook with multiple sheets. I turned on protection for each of the individual sheets, and used the "Allow users to edit ranges" to define sections, and set the permissions to "Everyone". It tests perfectly on my computer, but when I emailed the sheet to another user, not so. The user saved the sheet in her own folder. The ranges I defined cannot be edited on her copy. Suggestions? Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
protection / edit ranges
This level of protection was added in xl2002.
What version of excel does she run? Liz wrote: Excel 2002 I created a workbook with multiple sheets. I turned on protection for each of the individual sheets, and used the "Allow users to edit ranges" to define sections, and set the permissions to "Everyone". It tests perfectly on my computer, but when I emailed the sheet to another user, not so. The user saved the sheet in her own folder. The ranges I defined cannot be edited on her copy. Suggestions? Thank you. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
protection / edit ranges
That was it - she was on 2000 - upgraded her to XP with the rest of the
office, and we're all set! Thank you! "Dave Peterson" wrote in message ... This level of protection was added in xl2002. What version of excel does she run? Liz wrote: Excel 2002 I created a workbook with multiple sheets. I turned on protection for each of the individual sheets, and used the "Allow users to edit ranges" to define sections, and set the permissions to "Everyone". It tests perfectly on my computer, but when I emailed the sheet to another user, not so. The user saved the sheet in her own folder. The ranges I defined cannot be edited on her copy. Suggestions? Thank you. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow users to edit ranges for VBA objects | Excel Worksheet Functions | |||
Add Permission did not work in "Allow User to Edit Ranges" | Excel Discussion (Misc queries) | |||
Validation protection with named ranges | Excel Worksheet Functions | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
allow users to edit ranges | Excel Discussion (Misc queries) |