Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have made an application. All i want is that only i have permission to edit the cells or rows. rest employees can edit only those cells which i allow them to. is it possible? also i would like to place this document on a shared drive. n i want that no 2 users can make changes in it at same time. i.e. if one user s using it, n other triest o open it, he gets an alert that this user is using it. would you like to notify?

Is there any way out for both of my problems? i tried going to tools> allow users to edit range > added a range > permission > add > "entered the email ids" apply and clied on denied without password for this range and applied. but it dint work.

share|improve this question
    
Have a look here: officetooltips.com/excel/tips/… for instance. If it isn't enough, please edit your question to be clearer in your expecations – JMax Jul 23 '12 at 8:48

Yes

Go to Tools (or the Review tab if < 2007)

  • Protection (if < 2007)
  • Protect Sheet

You should have enough options in the new window which pops up.

share|improve this answer
    
Protecting the sheet locks the whole sheet for me also – Shefali Jul 24 '12 at 6:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .