Excel VBA - Entering code in Workbook_Open event for new workbook created by copying worksheets from original workbook
Posted on 2011-09-25
My originating workbook has code that generates a new workbook by copying some of its worksheets: Sheets(WksNamesArray).Copy
I want to add code to the NEW workbook's Workbook_Open event that will prompt the user to save the workbook. Is there a way to do that?