Hide Excel but show the Userfom ???

[Stift]

Hi, I've created a VBA-userform from where users can insert values int
an Excel-sheet.
Now the user only uses the Userform but see's in the background th
database.

Is it possible to Hide the whole Excel-file and only show th
Userform?


GreetZ from Stif

 

[Harald Staff]

Hi

Don't hide Excel, it can be used for other things than this <g>.

The common way to do this is
1) make the "userform.show" macro available as an Excel menu item or a
toolbar button (see
http://www.dicks-blog.com/excel/2004/05/custom_commandb.html for one way)

2) save your file as an addin (xla file). That's a workbook without visible
sheets.

HTH. Best wishes Harald

 

[Stift]

Something like : Application.Hide won't work?????

or Application.Minimize

 

[Chip Pearson]

Try code like

Application.Visible = False
UserForm1.Show

Be sure to make Excel visible when you close the form:

Application.Visible = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Harald Staff]

It might. What I was trying to say was that it's very common to have at
least two jobs open at the same time in Excel, she's built for that, and
some of us really hate files that hijack the whole application, or worse,
the whole computer.

Best wishes Harald