VBA Form, hidden Workbook

[aristodemus]

Hello,

i have a vba form which has many dataconnections to different sheets ot its workbook.
When i open the workbook the form shows automatically up.

What i want now and where I've problems:

The workbook (Excel) should not be visible when the form is displayed and teh user should not be able to enter the workbook or any sheets of it.
He should not be able to see the content of the workbook (never)

If the user has another (different) workbook opened this one should not be influenced in any way (The user should still be able to work with it , parallel 2 or more workbooks).

[cytop]

You could do something like the following in the userform. Move the code from Sub StartUp in the UserForm initialize event and include the FindWindow function as a private function in the form:

Please Login or Register  to view this content.

Don't forget to unhide when you close...

[xlbiznes]

try this solution.

[aristodemus]

But if this form open I'm not aqble to open another excel document. since the form is modal.
Do youo have a workaround for that?

[cytop]

Use

Please Login or Register  to view this content.

to open the userform

[aristodemus]

This is the code from the xls from xlbiznes

Private Sub Workbook_Open()
'make the workbook invisible and display the form
ActiveWorkbook.Application.Visible = False
UserForm1.Show
End Sub

if you make this vbModeless then you get the following behaviour:
If you open another xls and close it then you can see the xls which was set to visible false first

[cytop]

The only comment I have is the code in the workbook is setting the Application hidden - which will hide all open workbooks in that instance of Excel.

Try using the code I posted - that only hides the Workbook window containing the code. You will still have the issue of the modal userform, but you can just show it modelessly...

The mods here might like you to edit your post and include code tags around the code listing. This is simply a matter of editing the post, highlighting the code and clicking the '#' button on the toolbar...

[xlbiznes]

@aristodemus ,

sorry about the previous file, this is the updated one and it behaves the way you wanted.