Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.