Showing Excel Taskbar while useform is open

michael.gardner · Joined: 25 Feb 2008 Posts: 2

Hi,

I am a relative novice to using VB so bare with me.

I have created a database using VB in Excel to enter call sampling and
work sampling stats by way of a userform. The user form is set to hide
everything in the background, but it also hides the task bar icon at
the bottom of the screen.

Is there any way I can hide everything except the userform and the
task bar icon?

Many thanks

Mike

Archived from group: microsoft>public>vb>general>discussion

"Jan Hyde · Joined: 04 Oct 2007 Posts: 466

michael.gardner@o2.co.uk's wild thoughts were released on
Mon, 25 Feb 2008 03:02:35 -0800 (PST) bearing the following
fruit:

>Hi,
>
>I am a relative novice to using VB so bare with me.
>
>I have created a database using VB in Excel to enter call sampling and
>work sampling stats by way of a userform. The user form is set to hide
>everything in the background, but it also hides the task bar icon at
>the bottom of the screen.
>
>Is there any way I can hide everything except the userform and the
>task bar icon?
>
>Many thanks
>
>Mike

It sounds like you are actually using VBA, in which case
you'd be better off in an Excel VBA group.

--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde

"Rick Rothstein \ · Joined: 04 Feb 2008 Posts: 37

> ....The user form is set to hide everything in the background,
> but it also hides the task bar icon at the bottom of the screen.

What is it you did to set the UserForm to hide everything? There is no
HideEverything property that I am aware of.

Rick

Ralph · Joined: 04 Oct 2007 Posts: 4148

"Rick Rothstein (MVP - VB)" wrote in
message @TK2MSFTNGP03.phx.gbl...
> > ....The user form is set to hide everything in the background,
> > but it also hides the task bar icon at the bottom of the screen.
>
> What is it you did to set the UserForm to hide everything? There is no
> HideEverything property that I am aware of.
>
> Rick
>

That is a very unsatisfactory response. Haven't you learned your lesson yet?

-ralph

michael.gardner · Joined: 25 Feb 2008 Posts: 2

When I say it hides everything, I mean, it hides the excel screens and
anything else you may have in the background.

Hope this makes sense.

"Rick Rothstein \ · Joined: 04 Feb 2008 Posts: 37

I understand what "hide everything" means... the question I asked you is
what did you do to get the userform to do that? Show us the code you used to
make the userform hide everything.

Rick

wrote in message @z17g2000hsg.googlegroups.com...
> When I say it hides everything, I mean, it hides the excel screens and
> anything else you may have in the background.
>
> Hope this makes sense.