preventing change of certain cells

[Guest]

Hi
how can I "lock" some cells ie. not allow anybody to change them, yet leaving other cells free for input
Where can I find faq

Than

alekmil

 

[Dennis]

1. Press Ctrl+a to select the entire worksheet
2. Click Format in the menu, then Cells, then the
Protection tab.
3. Uncheck the Locked box and press OK
4. Select the cells that you don't want anybody else to
change.
5. Click Format in the menu, then Cells, then the
Protection tab.
6. Check the Locked box and press OK
7. Click Tools in the menu, then Protection, then Protect
Sheet.
8. Type a password, if desired, then press OK.
9. Confirm the password and press OK

-----Original Message-----
Hi,
how can I "lock" some cells ie. not allow anybody to

change them, yet leaving other cells free for input.

 

[Frank Kabel]

Hi
try the following:
- select the cells for which you want to ALLOW entries
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- goto 'Tools - Protection' and protect the worksheet


Frank

-----Original Message-----
Hi,
how can I "lock" some cells ie. not allow anybody to

change them, yet leaving other cells free for input.

 

[David]

=?Utf-8?B?YWxla21pbA==?= wrote

Hi,
how can I "lock" some cells ie. not allow anybody to change them, yet
leaving other cells free for input. Where can I find faq?

Thanx

alekmil

I know the Dennis and Frank offered the conventional method, but if you
don't want to Protect the sheet, here's an alternative I use:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim NoEdit As Range
Set NoEdit = Intersect(Target, Range("E39:E41")) '<-- adjust for yours
If Not NoEdit Is Nothing Then
Application.EnableEvents = False
Application.Undo
Application.EnableEvents = True
MsgBox "Sorry, You are not allowed to change this cell!", vbCritical,
"Permission Denied!"
End If
End Sub