Cell Protection
 

Isy,

You can do this only via VBA. Try

Worksheets(1).Protect UserInterfaceOnly:=True,Password:="whatever"

Note that the UserInterfaceOnly property doesn't persist after the
workbook is closed, so you should execute this code in the
Auto_Open procedure or the Workbook_Open event in order to
re-protect every time the workbook is opened.


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


"Isy Taman" wrote in message
...
Is there a way of protecting cells in a worksheet that
will prevent changes to a cell from keyboard entries but
WILL allow changes if it's through Vba code.

Thank you