Run macro when cell changes to call another macro

Hi all!

I wrote a code that makes a command button appear or disappear based on the value of cell J2 that uses the data validation function to allow the user to choose from a list (the list of which is on a hidden worksheet). However, this macro does not work unless I run it manually from the VBA editor. Is there a code that will call this macro whenever the user makes a different selection from the list in J2?

Thanks!

Update: I solved this myself!

After trying code after code for two days (keep in mind I'm new to VBA and everything I've learned is from Google searches), I used the following codes to make this work:

Please Login or Register  to view this content.

The code didn't work properly until I put it in the proper sheet rather than a general module.