Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking formulas without password protecting worksheet
Does anyone know how to lock a particular cell to prevent the changing or erasing of a formula without having to password protect the entire worksheet/workbook? My field is showing as locked, but is not preventing the deletion or change of the formula contained there in. We need to share this workbook without having to password protect it. Can anyone help? -- DayStar ------------------------------------------------------------------------ DayStar's Profile: http://www.excelforum.com/member.php...o&userid=32083 View this thread: http://www.excelforum.com/showthread...hreadid=518370 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking formulas without password protecting worksheet
DayStar, you have to protect the sheet for this to work, you don't have to
put in a password but the sheet must be protected, another option might be to warn the person when they select a cell with a formula, want keep them from changing or deleting it but might work, you could put some code like this in the worksheet code Private Sub Worksheet_SelectionChange(ByVal Target As Range) If ActiveCell.HasFormula Then MsgBox ("Please do not remove or change"), , ("Formula In Cell") Else End If End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "DayStar" wrote in message ... Does anyone know how to lock a particular cell to prevent the changing or erasing of a formula without having to password protect the entire worksheet/workbook? My field is showing as locked, but is not preventing the deletion or change of the formula contained there in. We need to share this workbook without having to password protect it. Can anyone help? -- DayStar ------------------------------------------------------------------------ DayStar's Profile: http://www.excelforum.com/member.php...o&userid=32083 View this thread: http://www.excelforum.com/showthread...hreadid=518370 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking formulas without password protecting worksheet
Another simple way is to use a different background colour for the
cells you do not want anyone to edit, eg bright yellow or green - just tell your co-workers not to do anything with the coloured cell(s). Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unprotect cells in a worksheet when I have forgotten the password | Excel Discussion (Misc queries) | |||
Add protect worksheet password in macro | Excel Worksheet Functions | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Locking and Protecting and NOT displaying formulas | Excel Discussion (Misc queries) | |||
view worksheet formulas | Excel Discussion (Misc queries) |