| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I protect cells w/formulas from being typed over?
PLEASE BARE WITH ME!!!! How can I block only the cell that contains the Formula but make it so they can keep inputting the daily numbers (I am sharing a spreadsheet that multiple people input daily numbers into. The thing is that sometimes they type over the cell that contains the formula that runs the whole sheet). -- lucifuge ------------------------------------------------------------------------ lucifuge's Profile: http://www.excelforum.com/member.php...o&userid=37307 View this thread: http://www.excelforum.com/showthread...hreadid=570163 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I protect cells w/formulas from being typed over?
Try using Sheet protection The attached link runs you through what you need to do http://www.uwec.edu/help/Excel03/ws-protect.htm VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=570163 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I protect cells w/formulas from being typed over?
Thank you!!!! -- lucifuge ------------------------------------------------------------------------ lucifuge's Profile: http://www.excelforum.com/member.php...o&userid=37307 View this thread: http://www.excelforum.com/showthread...hreadid=570163 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I protect cells w/formulas from being typed over?
By default all cells on a sheet are locked when the sheet is protected.
CTRL + a(twice in 2003) to select all cells. FormatCellsProtection. Uncheck "locked" and OK Now select the sections/rows/cells to protect and FormatCellsProtection. Check "locked" and OK ToolsProtectionProtect Sheet The section/row locking does not work if you don't protect the sheet. BTW........I rarely get nekkid with anyone on a first date<g Gord Dibben MS Excel MVP On Wed, 9 Aug 2006 18:33:10 -0400, lucifuge wrote: PLEASE BARE WITH ME!!!! How can I block only the cell that contains the Formula but make it so they can keep inputting the daily numbers (I am sharing a spreadsheet that multiple people input daily numbers into. The thing is that sometimes they type over the cell that contains the formula that runs the whole sheet). Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to share and also protect certain cells. | Excel Discussion (Misc queries) | |||
| How to protect some cells, but able to insert rows elsewhere? | Excel Discussion (Misc queries) | |||
| How do I protect certain cells? | Excel Discussion (Misc queries) | |||
| Protect Cells ??? | Excel Discussion (Misc queries) | |||
| how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
