I don't see how the following statement relates to the rest of your problem description or the code that you posted:
Originally Posted by Skygazer...
If I am NOT ready to Add Progress Bar process macro, I have a sheet with message stating "Wait Till This Message Disappears" to user.
I do not understand this statement:
I .select this sheet at the beginning of the macro BEFORE running the line code "Application.ScreenUpdating =false"Your code does not show selecting a sheet, although you have a comment that says you select a sheet. If Show_FileLoadMessage selects a sheet, then the problem could be inside that macro.
And this statement:
But when the Workbook_Open macro runs the sheet doesn't show as it should during the run process.What is "the sheet"? There is nothing in the code you posted that causes any sheet to show.
I still recommend that you attach your file.