Macro to Saving Workbook Sheets as Separate Macro-Enabled Workbooks

Hello!

Since I am not overly familiar with VBA, I've been attempting to tweak previously successful macros.
What I need is a macro that will save every sheet as a separate macro-enabled file.
Also, I would ideally like the new file name to contain the original name of file "master" worksheet and the sheet name. For example, Master.xlsm would be parsed into Master_Sheet1.xlsm, Master_Sheet2.xlsm, Master_Sheet3.xlsm etc...
Any assistance would be appreciated. Thanks!

This code does save each sheet in a separate file... but doesn't save as a macro-enabled file, and only saves with the sheet name without a reference to the master sheet. (I grabbed this code from: http://www.excelforum.com/excel-gene...workbooks.html)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks for your help!
I received an error from Microsoft Visual Basic (Run-time error '1004') when I went to ran this unfortunately: " This extension can not be used with the selected file type. Change the file extension in the File name text box or select a different file type by changing the Save as type."

Any thoughts?

Please Login or Register  to view this content.