Cell Protection
 

You could protect the sheet as normal and then have the code unprotect it, do the changes and then
re protect it. Just make sure you lock the VBA project for viewing else they will be able to see
the password you put in. You still have the risk of someone hitting CTRL+BREAK as the code runs
and managing to catch it whilst it is unprotected though.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"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