The best way to do this is to use the UserInterfaceOnly parameter
of the Protect method. This allows VBA to modify anything, but
locks out the user. Unfortunately, this property is not saved
with the workbook when the workbook is closed, so you'll need to
protect it when the workbook opens. E.g., in the ThisWorkbook
module, use code like

Private Sub Workbook_Open()
Worksheets("Sheet1").Protect Password:="abc",
userinterfaceonly:=True
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com






"Reggie" wrote in message
...
is it possbile to lock down every cell in a sheet then when a
code is run
temporarily unlock a specific cell allow it to be modified/let
a value be
entered in it, then lock the cell again so the user cant type
over it?