> I tried this. ... It still doesn't work.

Send me a example program like before and I'll have a look at it.

> Does this mean that I have to have all the worksheets and chartsheets everytime I create a workbook?

Currently, yes.