Excel Sheet Tabs

[villy]

I have been working with MS Excel for several years but started coding (VBA) for just a couple of months and still looking for some ideas..

I know somebody have the answer for my question, here it goes...
Is there a code in vba that I can tell excel how many number of sheet tabs should be in new workbook? In Tools/Options/General I know you can change it manually but I need it in code, why? Because I have a program that reads only when only two sheets exist in a new workbook otherwise it gives an error. I want the users (other than me) be able to use my program without error when they use it in their own computer.

Thanks for those who will share their ideas...
God bless

___________________________________________________
"For human, it is impossible but for God nothing is impossible."

 

[villy]

Im sorry Mr. Andrew, it has been solved. The other tread I have is the "Tooltip for Excel Sheet Tabs".
Maybe you can help me with that if you have something brilliant idea.
Thanks