Excel - Insert New worksheets

Hi,

Is there a way I can insert a specified number of worksheet (e.g. 35) without the insert - worksheet - click option?

Can I configure this on the menu bar anywhere?

Thanks
tahirihAsked:
Who is Participating?
 
SiddharthRoutConnect With a Mentor Commented:
Place this code in a module

Sub Sample()
    InsertSheets 35
End Sub

Sub InsertSheets(numb As Long)
    Dim i As Long
    If numb < 0 Then Exit Sub
    For i = 1 To numb
        Sheets.Add
    Next
End Sub

Open in new window


And then run the sub sample. You may also add a button to the toolbar to call this sub Sample.

Sid
0
 
tahirihAuthor Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.