This will create a new module called Module1 and open the code window for you. To do this, right-click on any item in the tree view and select Insert and then Module. What we want to do is make this available to any page in the workbook, so we want to create a new kind of object called a Module. Each worksheet in this workbook are listed under that and as well as an object called ThisWorkbook, which represents the entire workbooks. The tree view on the left shows the entire project (“VBAProject Book1”), then a folder called “Microsoft Excel Objects” that will list the objects (things) that are in this project.

Don’t worry, this is actually very simple. This will open a window that at least some have never seen. You will need to enter the script in the Visual Basic Editor that is built into Excel. However, as you can tell, there are images, links and different formats all over the place. This creates a spreadsheet with country name, alpha-2, alpha-3, numeric and ISO-3166-2 codes. To prepare for this, I am going to simply copy the entire table listed in the Current Codes section of the ISO-3166-1 country codes page listed above into Excel.

Remove the links for each country code.

Remove the links for each country name.

Remove the images for the country flags.

Remove the images for the sort buttons.

This is what we want to accomplish with this script. This is a lot of excess information that I would really like to get rid of so I can have a clean list of data. The table contains images for the sort buttons, images for the country flags, links to the individual pages for each of the countries listed as well as links to each country code page.

However, the text I copy generally has a lot of unneeded information.Ī great example of this is copying and pasting a list of countries and their ISO-3166-1 country codes from Wikipedia. I often find myself copying and pasting text from various sources into Excel in order to use its incredible text manipulation abilities to create hundreds of lines of code in mere seconds.

How to disable links in excel 2010