Export worksheets

I have a workbook with multiple tabs. I have code that allows gives a pop up, I enter a corresponding number to the tab I want exported and it exports to a new workbook. I use this exact code in multiple other workbooks and it works perfect. However, for some reason, it will not work in this one. Can someone please help me figure out what is wrong.

To test the macro, go to the second tab (T6M Annualized_Q1_Template) and click the button labeled "Click Here to Export Borrower Version."

Please Login or Register  to view this content.

thanks

Is there anyone who can help with the previous post. Why would the code shown above work in all my other workbooks, but not the one attached?

Is there anyone who can help with this? If the question is not clear, let me know.

Basically, I have posted code I am using. This code works in every workbook I have tried except the one I attached in my original post. Can someone please help me determine why it will not work in this book?