Protect cells

[MrDoc]

Hi,

Is there a way to protect some cells of a spreadsheet from user input (by typing only), yet letting button controls and VBA macros modify the values of those cells?

I need to prevent users from accidentally deleting formulas or values generated by VBA macros or controls, although they may delete values in some cells.

Thanks for any help.

MrDoc

 

[MrDoc]

Exactly. Controls are directly linked to cells. So, if they (and the cells) must be unlocked, any user can modify the values in those cells, although the macros would work. Maybe I'll stick to protecting cells containing formulas and leave all other cells unlocked (controls are locked, but that has no effect, as linked cells aren't). At least I would protect the formulas from being deleted...
Thank you very much and, if you have a better idea, help would (again) be much appreciated.
Best Regards,
MrDoc

 

[mikerickson]

You could link all the controls to a cell on a different (very?) hidden worksheet. The hidden worksheet would not need to be protected.
Cells on the protected worksheet could hold formulas that look to the hidden worksheet.

 

[MrDoc]

Seems to be a very good idea! I'll try it next, thank you very much!
Best Rgards,
MrDoc

 

[MrDoc]

And it worked fine for me, Mikericson! Thanks a lot!