There is not enough information to understand what you're doing or what the problem is. Can you attach your Excel file?

Also, this is not your problem but why not just use
Show_FileLoadMessage
instead of 
Application.Run "Show_FileLoadMessage"  'Select the Sheet with Message
It shouldn't make a difference but the code is simpler and easier to understand.