Locking Cells

S

Steve

How do you lock individual Cells so that user input cannot change it, BUT
it can change itself depending on Calculations from another cell on another
Sheet?

thx

Steve


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080116-0, 16/01/2008
Tested on: 16/01/2008 13:41:33
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com
 
M

Mike H

Simply protect the sheet and the cell will update if the inputs to the
formula in it change but you wont be able to change it manually.

To leave other cells on the sheet un-protected, select them and then
format|cells|protection
remove the locked chackmark

Mike
 

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

Similar Threads

Spin button 2
Hidding buttons 3
VBA time and date? 1
How do you hide ..... 2
Auto insert 2
Transparent button 5
reset a cell 5
Command button 2

Top