Hi,

I've just found this newsgroup and I have a problem that has me stumped. I
have taken over a really complex workbook project that contains a lot of
complex code (macros).

We have a requirement for this workbook to go to various countries and
display the dollar values in the local currency. In a couple of these
countries the values are all priced in USD, but there are specific pages
that need to be displayed in a different currency format. I have allowed
the user to choose a secondary currency type from a drop down control (which
determines which ascii code to use for the symbol) and to enter the exchange
rate in a cell underneath that. Doing the exchange calculation is no
problem, but applying the secondary currency style is a big challenge. Is
there anyway that I can change the styles on an entire worksheet from one
custom style to another? Ie. "LocalCurrency [2]" to "SecondaryCurrency". I
know how to do it for the entire workbook, but it is only specific sheets
that need to be changed.

Any help would be greatly appreciated.

Thanks,
Sherry

Sorry I meant custom styles, not customer styles. Any help or guidance on
this is greatly appreciated.

Thanks,
Sherry

"Sherry" wrote in message
...
Hi,

I've just found this newsgroup and I have a problem that has me stumped.
I
have taken over a really complex workbook project that contains a lot of
complex code (macros).

We have a requirement for this workbook to go to various countries and
display the dollar values in the local currency. In a couple of these
countries the values are all priced in USD, but there are specific pages
that need to be displayed in a different currency format. I have allowed
the user to choose a secondary currency type from a drop down control
(which
determines which ascii code to use for the symbol) and to enter the
exchange
rate in a cell underneath that. Doing the exchange calculation is no
problem, but applying the secondary currency style is a big challenge. Is
there anyway that I can change the styles on an entire worksheet from one
custom style to another? Ie. "LocalCurrency [2]" to "SecondaryCurrency".
I
know how to do it for the entire workbook, but it is only specific sheets
that need to be changed.

Any help would be greatly appreciated.

Thanks,
Sherry

I resolved this problem, so no need for help any more.

Thanks,
Sherry


"Sherry" wrote in message
...
Sorry I meant custom styles, not customer styles. Any help or guidance on
this is greatly appreciated.

Thanks,
Sherry

"Sherry" wrote in message
...
Hi,

I've just found this newsgroup and I have a problem that has me stumped.
I
have taken over a really complex workbook project that contains a lot of
complex code (macros).

We have a requirement for this workbook to go to various countries and
display the dollar values in the local currency. In a couple of these
countries the values are all priced in USD, but there are specific pages
that need to be displayed in a different currency format. I have
allowed
the user to choose a secondary currency type from a drop down control
(which
determines which ascii code to use for the symbol) and to enter the
exchange
rate in a cell underneath that. Doing the exchange calculation is no
problem, but applying the secondary currency style is a big challenge.
Is
there anyway that I can change the styles on an entire worksheet from
one
custom style to another? Ie. "LocalCurrency [2]" to
"SecondaryCurrency".
I
know how to do it for the entire workbook, but it is only specific
sheets
that need to be changed.

Any help would be greatly appreciated.

Thanks,
Sherry