General information
Category:
Windows API functions
>When I create a new workbook, Excel automatically comes up with 3 worksheets. I only want 2.
>
>When I'm done filling in the first 2, i do a
>m.oExcel.Worksheets(3).delete()
>
>this works but the user gets an excel nag sheet asking them if they really want to delete the worksheet. i, of course, don't want them to see that.
>
>any ideas how i can delete that 3'rd sheet quitely (or maybe never get it to begin with).
>
>thanks
>
>scott vandenelzen
In Excel goto Tools , Options, General and change the value of Sheets on new workbook to 2.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only