Changing calculation mode using buttons

Built-in Function Button, see Multi-languages sample estimate (bottom of Sheet of Sales)

Copying/clearing areas within the workbook

ibidem, see Multi-languages sample estimate (Sample function)

Managing exchanges with foreign workbooks

ibidem

Setting up currency rates from a free sheet or an external source

ibidem, see Multi-languages sample estimate (bottom of Sheet of Sales)