Unfortunately, I suspect this is impossible

If you use VBA code, you would continually have to update the cells covered

You could resort to Conditioning Formatting to indicate cells that must be filled; however, a file could still be saved