ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prevent running macro upon closing Excel (https://www.excelbanter.com/excel-programming/322236-prevent-running-macro-upon-closing-excel.html)

Deneb

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?


Juan Pablo González

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?




Deneb[_2_]

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