Overriding Default Currency

Hello,

I have a macro that performs calculations on dollar amounts. Based on the input in the first spreadsheet, the macro will produce another spreadsheet with certain prices based on previous input.

The problem is that the default currency chosen (specified through the control panel) will always override the currency specified in the spreadsheet.

For example, if the default currency is $, and I specify pounds in my spreadsheet, the macro will spit out a new spreadsheet where everything is in $ (USD). I would like to find a simple way to override the default currency specified in the control panel, so that if I type in $, the macro will produce a result with $, and if I type in pounds, the macro will produce a result with pounds.

Please let me know if this needs any further clarification.

Thanks for your help,

J.R.

the file with the macro would be a good start


Cheers
Leo

Is there a simple function/setting that can be applied to make sure the currency isn't changed when running the macro?

The reason it is occurring is because of the default currency option set through the control panel. Just wanted to see if there is a way to have excel ignore this option.

-J.R.