G'day, I am trying to minimize excel while running a questionaire based on a series of userforms.
The forms access a number of worksheets in the same workbook.
Ive tried this when the first form initializes but it stops the form from appearing;
Ive tried this but if the forms are stopped before the end it appears as though excel is closed yet it is still open, jsut not showing anywhere not even down the bottom;Code:Application.WindowState = xlMinimized
with;Code:Application.Visible = False
at the end.Code:Application.Visible = True
any ideas?




Reply With Quote