| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel cell and data formatting
Can I setup cells in a worksheet to accept data from a different location using formuals and then prevent users from directly entering data into those same cells. I wan the cells to receive the data from the formula, but prevent users from directly entering data to that cell.... my example is cell b3 gets data sum from cells b12thru i12 using a formula embedded in b3) I want to prevent someone from just accidentily entering data in b3 instead of the associated cells (b12 thru i12) thus preventing someone from eliminating the formula in place (in b3) and cause problems with the rest of my sheets. tks, if you have an answer ratt out -- ratt ------------------------------------------------------------------------ ratt's Profile: http://www.excelforum.com/member.php...o&userid=24318 View this thread: http://www.excelforum.com/showthread...hreadid=379229 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data bar conditional formatting based on another cell | New Users to Excel | |||
| Formatting Data in cell in colour | Excel Discussion (Misc queries) | |||
| Copy data to new cell but with different formatting | Excel Discussion (Misc queries) | |||
| Cell formatting when importing data | Excel Discussion (Misc queries) | |||
| Cutting Data from cells changes Cell Formatting | Excel Programming | |||
Threaded Mode
