Dear all,
I have a workbook with only 1 sheet (Sheet1) in which I have keyed in some ActiveX controls of Option buttons (Nearly 100+ in count) and completed coding related to them.
Now I'm in need of a VBA code to do the following:
1) Code must pop-up a input box to the user asking number of sheets required to be added into existing workbook.
2) After user provides the data, it must add so many sheets to workbook with the same content of "Sheet1".
3) Naming of extra sheets must be in sequence, like 'Sheet2 sheet3 sheet4.....' so on...
4) Please make your code more general to any number of pre-existing sheets.Like if I have 10 sheets already, code must add sheet11 sheet12.....so on....If I have 3 sheets, it must add sheet4, sheet5.....so on....
Thanks in advance.
Bookmarks