I have written a routine in VBE which causes excel to run a series of
calculations.

A user will need to fill in several inputs in excel, and then run the
routine.

I would like to lock areas of the worksheet which the user should not
touch, so that they can't accidentally change the formulas/cells that
VBE is using for the calculations.

When i lock the cells that VBE needs to use then the macro will not run
until the worksheet has been unprotected.

Is there a way of locking a cell to a user, but allowing a macro to
update that same cell with the without the user having to unprotect the
worksheet?

Thanks

N


---
Message posted from http://www.ExcelForum.com/

Hi Nigelbellamy,

Is there a way of locking a cell to a user, but allowing a macro to
update that same cell with the without the user having to unprotect the
worksheet?


The protection method has a UserInterfaceOnly property.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com