Hello,
I have an xlsm file that has multiple userforms. When I open the file it shows the Excel application and the worksheet that was last saved briefly before going to frm_Show_Splash userform. I've tried to use the following code in the ThisWorkbook module, but it still does it. Is there any other way of doing this?
Thanks
Please Login or Register to view this content.
BigD
How about moving it to a close for hiding the sheet as far as not have Excel show for the quick second I'm not sure of any other way to achieve that
Please Login or Register to view this content.
Thanks for the replay meabrams,
I tried it, but got the same results.
BigD
Just a note to say I was unable to solve this.
BigD
How about designing a special sheet (? all one empty cells with attractive fill color") specifically for the brief splash and use code like
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
The only thing I could think of was to change to a blank sheet called "Spare" before saving and closing the Workbook. So when the file is opened again it shows the blank Sheet for a split second.
Please Login or Register to view this content.
Try this :
Show the sheet after you close the form :Please Login or Register to view this content.
Please Login or Register to view this content.
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
Causes Object Variable or With Block variable not set when I Activate Sheets in my second Userform Initialize
BigD
The reason for that error is that there isn't (quite) a Window when the Open event runs.
One way to fix those kinds of errors is to move from the Open event to the Activate event. The difficulty comes that the Activate event triggers when you switch between open workbooks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks