Can macros alter locked cells in excel?

  • Thread starter Thread starter nigelbellamy
  • Start date Start date
N

nigelbellamy

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
 
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?
Click to expand...

The protection method has a UserInterfaceOnly property.

Regards,

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