xld,

I have been exploring your suggestion regarding the use of add-ins to house the code outside of the workbook. I don't have much experience with add-ins.

I think I see the value though, especially with Excel 2007. If the code is contained in a companion add-in, then the user can save the workbook as an .xlsx without any negative repercussions.

The downside, it seems to me, is that each user must have the workbook and the companion add-in to achieve full functionality. One w/o the other won't work.

I have a question. Is it possible to build an add-in that contains code work for several different workbooks or is it a better practice to have each workbook matched with a unique and corresponding add-in?

Thanks,

Ron