Hide all worksheets until userform is displayed?

[GJW]

In a workbook_open sub I do some tasks and then have frmOpening.Show.
What happens is a worksheet Sheet1 (that I want to display later by clicking buttons on the opening userform) shows before the frmOpening user form displays.
This is very distracting for the user and looks unprofessional.
I would be grateful for any suggestions.

 

[Andrew Poulsom]

You can minimise the workbook in your Workbook_Open event procedure like this:

'   Minimise all open workbooks
    For Each Window In Windows
        On Error Resume Next
        Window.WindowState = xlMinimized
        On Error GoTo 0
    Next Window
'   Activate this workbook (minimising activates next open workbook)
    ThisWorkBook.Activate

But even then there will be a short interval when the sheet is displayed.

I find the best solution is to create a blank sheet, turn off gridlines and row and column headers etc, adjust the height of row 1 and the width of column A so that cell A1 is very small and place the cellpointer there. Then make sure that this is always the active sheet when the workbook is saved.