• Check out world news on HeadLinesList.com
  • Forum registration is now open for public.
Hello There, Guest! Login Register

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to achieve this in Microsoft Excel?
I have a column A where I can enter a value and another column B where I calculate something based on this.I want to protect B so that the user can only enter values in A.I know one can use lock and then protect the sheet but I dont want to password protect the worksheet for this.
How can I disable the user from entering values into B even by mistake and only be able to enter into A alone.

Also is it possible I can create a form/user interface using macro on this so that it looks more user friendly where I can enter the value (corresponding to column A) and see the result come up on the form.



You can lock ranges of cells ..

Tools > Protection > Allow users to edit ranges

You can set passwords for individual ranges and more, no need for macros


Do this:


A password is OPTIONAL, so just leave the box empty.

Forum Jump:

Browsing: 1 Guest(s)