Creating n number of worksheets based on userform input

Hello

As part of my project I have a master worksheet and an 'n' number of worksheets that people will use for data entry. That way I don't need to give anyone access to the master worksheet. Currently the macro creates two worksheets in the workbook (one master copy and one copy for distribution). The distribution copy is different structurally than the master worksheet and that's why it has its own worksheet.

(1) What I would like help doing is creating a macro that would open a userform asking for the 'number of copies for distribution' and create new workbooks with that number provided by the user.

(2) Once the workbooks are created, close each one prompting for a file name and a location to save them.

Thanks in advance.

abousetta

Give this a try. Adjust the sheet name per your needs. The sheet name used is the code name not the worksheet name in the tab.

Please Login or Register  to view this content.