insert worksheets

I need to create a VBA that asks how many workbooks we want to create and then save them numbering them 1.xlsx to however many we end up with. I have started the macro but I only know how to write it using this and it only gives me 10. I need it to ask how many we are going to create. Sub 2()...

I have a bit of code that I have used Sub Copy_sh() Dim SDrv As String Dim DDrv As String Dim Sfname As String Dim Dfname As String Dim wkbSrc As Workbook Dim wkbDst As Workbook Dim strFName As String strFName = Sheet1.Range("A1").Value Workbooks.Open...

Using Excel 2010 under Windows 8. The default font options set in my Excel for New Workbooks are: Body Font (which is Calibri on my computer) and size 11. If I open a new Workbook this font type and size are applied. If I add a new worksheet in this workbook, again this font type and size are...

I've just got Excel 2010 :-( (and hate it). When I press the "insert worksheet" button next to my tabs, Excel inserts three of them, not just one. This is deeply frustrating. Why does it do it, and how do I change it? Thanks in advance.