April 18th 07, 04:12 PMposted to microsoft.public.excel.misc | ||
| ||
Allow Users to Edit Ranges??? The user is unable to selected the locked cell. It does not prompt the user for a p/w. Does it matter if the cells are locked and the worksheet protected? 'Dave Peterson' wrote: Once you protect the worksheet and allow ranges to be changed, anyone who tries to change one of those ranges will be prompted for a password. There's nothing you have to do special. Excel will do it for you. MarcusA wrote: I'm not sure if I'm doing something wrong. I have a workbook with two worksheets. On the first worksheet, I have standard p/w protection with several unlocked cells. What I would like to do is grant specific users access to additional cells within the worksheet. I list my ranges, add users to the permissions list and select a password. How does the user unlock this area of the worksheet using the p/w? Secondly, trying the same process and not using a p/w does not work either. Thanks -- Dave Peterson |