Its really very simple.....
To enable Visual Basic code for Excel: Click on Tools -> Macros -> Security High does not allow you to run VB code. Medium asks you before running any code. Low runs all VB code.
Enter supporting content here