Hello Dear Board Users,
this is my first post, my Name is Patrick and I am currently working in Japan...
So, here is my problem:
I have an Excel Table with ca. 10 sheets showing asset reports. As the currency is selectable via a switch, I would like to insert a label displaying the current currency.
This label should appear on every sheet and be updated when changing currencies.
Unfortunately, Excel calculates the numbers 10 times when doing so...
Here's the code:
Thanks for your replies!
Patrick
this is my first post, my Name is Patrick and I am currently working in Japan...
So, here is my problem:
I have an Excel Table with ca. 10 sheets showing asset reports. As the currency is selectable via a switch, I would like to insert a label displaying the current currency.
This label should appear on every sheet and be updated when changing currencies.
Unfortunately, Excel calculates the numbers 10 times when doing so...
Here's the code:
Code:
Sub Eurosign()
For Each Sht In ActiveWorkbook.Sheets
If Sht.Name <> "Data" And Sht.Name <> "DataYen" And Sht.Name <> "DataYenRAW" And Sht.Name <> "DataEuro" And Sht.Name <> "Data_PsGG" And Sht.Name <> "stammdaten" And Sht.Name <> "SAPBEXfilters" And Sht.Name <> "SAPBEXqueries" Then
Label1.Caption = "€"
End If
Next Sht
End Sub
Thanks for your replies!
Patrick