Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The macro is very simple:
Private Sub ComboBox1_Change() Range("E1").FormulaR1C1 = "EUR" End Sub Original macro is more complex, but I have tried to find solution for this problem with simplier macro. Every time I close workbook Excel runs this macro and writes EUR to cell E1. I'm using Excel2002/Windows2002. Brgds, Jussi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto running a macro on closing | Excel Discussion (Misc queries) | |||
Prevent A Macro From Running If SpreadSheet is Filtered | Excel Worksheet Functions | |||
Running a macro Upon Closing | Excel Programming | |||
VBA Help - Running a macro when closing print preview | Excel Programming | |||
Closing the Userform when macro is running | Excel Programming |