Keep From Clearing Data Within Hidden Cells

[LordJesterX]

Good morning. I've used this forum a lot, but apparently never posted anything because I didn't have an account, so this is my first official question!

This may be super simple, but I'm trying to keep from clearing out data from hidden columns when you select a group of cells and hit delete. I have a formula hidden between two columns, and I know people using this sheet will put information in and continually delete it. I don't have the option to protect this particular sheet. Is there anything I can do to keep this from happening?

Thanks in advance!

 

[kanadaaa]

Hi, that can be achieved if it's possible to save your workbook as a macro-enabled workbook (.xlsm).