I want to know if there is a way to make a range not visible when an excel sheet is opened. The range is formatted as a data validation dropdown. I tried using code from a recorded macro to unformat the range so that it just blends in with the page and clears the contents, but for some reason it didn't work. I put it in to the code for a "Next" button that the previous programmer has on it. This is NOT a form, only a sheet, so there is no Form_Load here.
The options on one dropdown are: High, Medium, Low. The other is Yes,No. That's the condition. If NO I want the Hi/Med/Lo dropdwon to disappear. If YES, it stays.