Yes, you can put a macro in a module instead of on the sheet, but it won't automatically execute when a value in column 11 is changed. You would have to find some other way to trigger the macro, such as running it manually, putting a control on the sheet that triggers the macro, etc.