Changing Customer Styles in Code
 

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

Changing Custom Styles in Code
 

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

Changing Custom Styles in Code
 

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