How do I create a macro in Excel for Mac?

I have found this thread on this topic
How to get the list of sheet names of ms-excel?

But I have no idea how to create the macro people are talking about. I will be grateful for your help on how to create the macro with the suggested code.