I tried and gave up.

Why don't you instead start with a copy of a workbook that is empt
except for the VBA modules and form(s) and just make copies of tha
workbook?

It might not be as elegant as what you are doing, but it would be a lo
simpler

--
Message posted from http://www.ExcelForum.com