Now click the icon showing the dog-eared page with the Excel logo on it. The code & [File] should appear. Now click OK. The file name will appear in the header when you print the file.

After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply ...