Changing Customer Styles in Code

  • Thread starter Thread starter Sherry
  • Start date Start date
S

Sherry

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
 
I resolved this problem, so no need for help any more.

Thanks,
Sherry


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

Thanks,
Sherry

Sherry said:
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
Click to expand...
"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
Click to expand...
Click to expand...
 
Back
Top