You need to add a change event to the sheet in question and have it react
only to the specific cell that is performing data validation.
--
http://HelpExcel.com




"JDay01" wrote:

Hopefully this is a simple question.... I need to have a macro run
automatically when a user makes their selection from a data validation
drop-down box. The macro name is Hide_Columns. What is the code needed to
execute this macro upon their selection?