I have written a macro (with help from this forum, thanks) that prompts a user for 3 files to import worksheets, then it creates custom headers and footers for those worksheets, prints them out, and deletes them. Now I need another macro for situations where the number of, and which worksheets needed, will not be known until the first worksheet is opened.

How can I modify the following code to prompt the user for the first file, modify and print, then ask the user if they need to open another file and repeat the process?

Please Login or Register  to view this content.