Sure this is basic question and that the reason that I cannot find
the answer outside the news groups is that I am not asking the right
question ...

I have taken an excel 2003 VBA appilcation and am making changes to it
in 2007. I am adding the statment 'worksheets.add after ....' however
the sheet just overlays the main sheet. The odd thing is that on the
main sheet I cannot see the sheet tabs at the botton the of workbook/
sheet. This is where the problem lies I think but I cannot see how to
fix it, ie how to make it look like any new workbook that I open in
2007 with the tabs at the bottom.

Hope this makes sense.

Regards

Rob