• 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?
#1
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.

thanks
Alex
Reply

Ads

#2
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
Reply

Ads

#3
Do this:

http://www.officearticles.com/excel/cell_locking_in_microsoft_excel.htm

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


Forum Jump:


Browsing: 1 Guest(s)