Thanks for your further detailed replies with broad outlook. Your notes on
writing code for future releases will come in handy, as I no doubt will find
myself having to go there too some day.

Sorry my code crashed your machine, as well as excel. I hope with no
permanent damage. It's hard to write code that breaks things "perfectly" and
to the point. In this case I likely added unnecessary corruption to the real
bug by assigning the sheet2 name to an already existing component by that name
- given that the default number of new sheets in a new workbook is greater
than 1!

All the best!

|\|.

On Sun, 4 Dec 2005 12:46:49 -0000, "Peter T" <peter_t@discussions wroth:

Hi Nick,

Can you tell me of a good reference document on working with the VBProject
class?

My introduction was from Chip Pearson
http://www.cpearson.com/excel/vbe.htm