Workbook protection

S

Sri Harsha

I see that after protection, the option "Allow users to edit ranges" is
greyed out and it does not let me select that. I am using Excel 2007. Any
other suggestions?

I want to restrict editing a couple of columns in my worksheet.
 
E

Eduardo

Hi,
Once you protected the sheet that option is not longer available, what you
have to do is to unprotect the cell where you want the users to have access
then when protecting the sheet they will be only able to edit the unprotectec
cells

Was this helpful please press yes at the bottom of the screen. Thank you
 

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

Top