Start macro with excel minimised

[John Yazou]

Hi all,
I have UserForm1 in my workbook. Is there a way such that whenever the workbook is opened, UserForm1 is displayed, and Excel minimised. Also, any similar techniques for MS-Word??
Thanks a bunch..

 

[Maslan]

Hi,
Go to VBA Editor, add these codes to ThisWorkbook/ThisDocument object.

For Excel:

Private Sub Workbook_Open()
Application.WindowState = wdWindowStateMinimize
Load UserForm1
UserForm1.Show

End Sub


For MS-Word:

Private Sub Document_Open()
Application.WindowState = wdWindowStateMinimize
Load UserForm1
UserForm1.Show
End Sub

 

[Paul-Johnson]

Try this

Copy it into the "this workbook module"

It is an auto open macro that runs anytime the workbook is opened. To bypass it - hold down the shift when you open the workbook

Private Sub Workbook_Open()
ActiveWindow.WindowState = xlMinimized
Application.ScreenUpdating = False
Call "procedure that loads your form"
Application.ScreenUpdating = True
End Sub


Good luck

 

[Jay Petrulis]

Hi John,

In your Workbook_Open routine, include the following:

ActiveWindow.WindowState = xlMinimized
UserForm1.Show
ActiveWindow.WindowState = xlMaximized

When you dismiss the userform, the window state is is maximized (use xlNormal to return to the visible, non-max state).

Note that you cannot use

Application.WindowState = xlMinimized

to hide Excel from view and then work with the userform, you can only minimize the active windows.

HTH,
Jay

 

[]-[ /-\ \/\/ /-\ | | /-\]

Or, yet another way which I use to hide Excel when opening a workbook with a custom password dialog:

Application.Visible = False
'do your thingy
Application.Visible = True

this hides Excel completely, then shows it when invoking "True."

Aloha!

 

[Sbirro Cornuto]

On 2002-03-20 17:02, Jay Petrulis wrote:
Hi John,

In your Workbook_Open routine, include the following:

ActiveWindow.WindowState = xlMinimized
UserForm1.Show
ActiveWindow.WindowState = xlMaximized

When you dismiss the userform, the window state is is maximized (use xlNormal to return to the visible, non-max state).

Note that you cannot use

Application.WindowState = xlMinimized

to hide Excel from view and then work with the userform, you can only minimize the active windows.

HTH,
Jay

What do mean Jay? Yes you can!