Thnaks for the replies.

Do you know how i add/remove using VC++ rather than VBA?

Cheers
Macca


"Rob van Gelder" wrote:

True... Why didn't I think of that? ;) Sometimes I do things the hard way

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"keepITcool" wrote in message
...

or do this?..

dim lSNW&
lSNW = Application.SheetsInNewWorkbook
Application.SheetsInNewWorkbook = 2
workbooks.add
Application.SheetsInNewWorkbook= lSNW





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Rob van Gelder wrote :

There is a setting:
eg.
Application.SheetsInNewWorkbook = 2
(That's VBA, not C++)

However, this is a preference for the user which is saved as Excel is
closed.
When the user next opens Excel, they'll get as many sheets as you
last set.

If I want to create a book with 2 sheets then I write code to add
sheets if they are missing, remove sheets if there are too many.