They are on worksheets...about 20 different ones, they transfer data to a secondary worksheet for data collection. Each has different rules...different calculations, different columns, some have a series of charts involved, so remaking them all isn't really an option.

I feel like there is something being selected, some option being enabled that I am missing here, for all the controls to be basically shut down at once.

Thanks,
Jim