Wil Moosa
Well-known Member
- Joined
- Aug 11, 2002
- Messages
- 893
I start my workbook right from the beginning with a (logo)form with no (background) sheet visible. The sheet appears only áfter the form has disappeared (The form stays visible 6 seconds using some timer code).
I used the following code to get it running:
I placed Application.Visible = False as one of the first lines of the code of Thisworkbook (Private Sub Workbook_Open)
I placed Application.Visible = True as one of the last lines of the form code (Private Sub UserForm_activate).
It worked for more then a month... and then suddenly it does not work anymore. Background sheet and form start at the same time. It is not only that it does so in the workbook I'm talking about, it does also in back ups of the workbook.
What has happened?
I used the following code to get it running:
I placed Application.Visible = False as one of the first lines of the code of Thisworkbook (Private Sub Workbook_Open)
I placed Application.Visible = True as one of the last lines of the form code (Private Sub UserForm_activate).
It worked for more then a month... and then suddenly it does not work anymore. Background sheet and form start at the same time. It is not only that it does so in the workbook I'm talking about, it does also in back ups of the workbook.
What has happened?