Why not just place your code in your personal.xls workbook or by creating an
Addin. Writing and erasing code with code is a bit tricky unless you are
reasonably adept with VBA...
--
HTH...

Jim Thomlinson


"bobbo" wrote:

I want to change the color of the active row in a spreadsheet to make
it easier to read. I have the code that accomplishes this task but I
want it to work more like an excel option rather than put it on
individual workbooks. Is there a way to insert the code I want when the
workbook opens then delete when the workbook is closed.