PDA

View Full Version : Solved: Minimize excel



gibbo1715
10-28-2005, 12:24 PM
Is it possible to hide excel when a userform is displayed but still leave it in the system tray?

I know how to hide it completely (Application.visible = false) and i know how to make it small and hide it behind my userform (So it stays in the system tray)

But can it be invisible, show the userform and be in the system tray as well?

Cheers

Gibbo

Bob Phillips
10-28-2005, 12:27 PM
application.WindowState = xlMinimized

gibbo1715
10-28-2005, 12:39 PM
Been wondering if that was possible for ages

Cheers

Gibbo