Prevent running macro upon closing Excel

  • Thread starter Thread starter Deneb
  • Start date Start date
D

Deneb

Excel runs Combobox-macro of active sheet every time I close the file. How
can I prevent this happening?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Macro to generate powerpoint slides 43
Macros Stop Working 4
Undesirable sorting behavior 1
Macro Related to Paste Values 2
starting Word from an Excel macro 3
Macro Compatibility between 03 and 07 2
Run macro from active workbook whose name keeps changing 20

Back
Top