userform's

[fryes04]

I have created a userform for users to update and recieve data, however I seem to be stuck. Why is it that when I close the userform, it closes all other excel documents that are currently open as well.

I'm using:

thisworkbook.application.visible = false
userform1.show

on open.......how do I set this userform to close just the workbook it is related to and not all other workbooks as well.

any help would be appreciated.

Thanks
Steve

 

[Smitty]

Welcome to the Board!

Why not set the User Form to full screen view?

<font face=Calibri>        <SPAN style="color:#007F00">'   DIsplay the User Form in Full Screen mode</SPAN><br>             .WindowState = xlMaximized<br>             Zoom = Int(.Width / Me.Width * 100)<br>             Width = .Width<br>             Height = .Height</FONT>

HTH,

 

[fryes04]

Hi

Thanks for the quick reply. I have already set it for full screen, thank you.

What I'm looking to have happen is when the user form is closed, the work book related to the user form also closes, but only that work book. At the moment all workbooks are closing, but when I go to open one of the other workbooks, it gives the message ""would you like to reopen ****** as if it has hidden the other work books. how do I tell VBA to only hide of close the work book relating to the userform.

Thanks

 

[fryes04]

The reason for this, is I don't want anyone to view the data on the sheets.

thanks

 

[Smitty]

If you have a Close button for the form you can just use:

Activeworkbook.Close True