Edit Range of a protected worksheet

S

SnJ

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

allow a user to edit ranges in a protected worksheet 3
Protected worksheet/tab key 2
Sheet Protection / Edit Objects 0
Protect conditional formatting in destination cell 2
Copy protection from one worksheet to another 1
when I protect a worksheet, user cannot use check boxes 4
Using tab key in protected worksheet 4
Can you allow users to copy & paste protects cells 0

Top