Hide Excel but show the Userfom ???
 

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? :confused:


GreetZ from Stif

--
Message posted from http://www.ExcelForum.com

Hide Excel but show the Userfom ???
 

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..._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 " skrev i melding
...
Hi, I've created a VBA-userform from where users can insert values into
an Excel-sheet.
Now the user only uses the Userform but see's in the background the
database.

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


GreetZ from Stift


---
Message posted from http://www.ExcelForum.com/

Hide Excel but show the Userfom ???
 

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

or Application.Minimize

--
Message posted from http://www.ExcelForum.com

Hide Excel but show the Userfom ???
 

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





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

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


GreetZ from Stift


---
Message posted from http://www.ExcelForum.com/

Hide Excel but show the Userfom ???
 

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

"Stift " skrev i melding
...
Something like : Application.Hide won't work?????

or Application.Minimize ?


---
Message posted from http://www.ExcelForum.com/