| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
