UBS Interview Question

Explain how macros on excel work