Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Edit Range of a protected worksheet
Hi
Is it possible to have a defined range to be chosen for allowing users to edit rather than a definite range. 'Allow Users to Edit Ranges' [Tools = Protect]. For example enter the function =indirect({Defined Name}) where the defined name changes based on the data entry made by users. This is very useful in the case of protected worksheets with forms to be filled up by users. Regards SnJ |
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 | |||
Can't Edit Contents of Protected Worksheet | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
How can I copy/edit a protected worksheet without the password? | Excel Discussion (Misc queries) | |||
Edit specific range in protected worksheet | New Users to Excel |