Hi,

I have a series of worksheets that require inputs from operators, which then
go into a series of formulas so they can follow progress and decide what to
do next. They need to hit macro buttons which then +1 or -1 or save or
delete data etc, which is then displayed firstly as a number and then in a
sort of graph - all of which is driven by hidden tables and formulas.

I would like to lock all cells, except the macro's. Some of the locked
cells will need to change as the buttons are used.

Is this possible or do all cells that change, be it with direct inputs or
formulas need to be unlocked?

If it is not possible how can I avoid this problem? I cannot afford to
leave all formula cells unlocked or the worksheets will get 'adjusted'.

Thanks
LiAD

I found a bit of code on this site from another user that I managed to adapt
for what I needed.

Job done

Thanks

"LiAD" wrote:

Hi,

I have a series of worksheets that require inputs from operators, which then
go into a series of formulas so they can follow progress and decide what to
do next. They need to hit macro buttons which then +1 or -1 or save or
delete data etc, which is then displayed firstly as a number and then in a
sort of graph - all of which is driven by hidden tables and formulas.

I would like to lock all cells, except the macro's. Some of the locked
cells will need to change as the buttons are used.

Is this possible or do all cells that change, be it with direct inputs or
formulas need to be unlocked?

If it is not possible how can I avoid this problem? I cannot afford to
leave all formula cells unlocked or the worksheets will get 'adjusted'.

Thanks
LiAD