![]() |
Prevent running macro upon closing Excel
Excel runs Combobox-macro of active sheet every time I close the file. How
can I prevent this happening? |
Prevent running macro upon closing Excel
What's the macro on the combobox ?
-- Regards Juan Pablo González "Deneb" wrote in message lkaboutsoftware.com... Excel runs Combobox-macro of active sheet every time I close the file. How can I prevent this happening? |
Prevent running macro upon closing Excel
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 |
All times are GMT +1. The time now is 01:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com