Display Form only!

[Noggin]

Hi All,

I'm developing a form which I'm hoping will act as the only interfac
the intended users will need to use. With som help from the forum I'v
solved most of the problems I forsaw and am now trying to tart th
thing into it's final presentation state.
My question for those the forum is :- Can you hide excel, worksheet
etc, leaving only the form on screen?

Thankx for your thoughts

Noggi

 

[Ron de Bruin]

Hi

You can use this events in the Form

Private Sub UserForm_Initialize()
With Application
..Visible = False
Me.Top = .Top
Me.Left = .Left
Me.Height = .Height
Me.Width = .Width
End With
End Sub

Private Sub UserForm_Terminate()
With Application
..Visible = True
End With
End Sub

 

[Noggin]

Hi Ron De Bruin

Thank you very much. The code worked fine all I have modifies is th
full screen for form which I didn't need. Here is the code I am no
using:-

Private Sub UserForm_Initialize()
With Application
.Visible = False
End With
End Sub

Also what were the double full stops ".." about they gave me errors
only when I reduced them to singles did the code work.

Anyway thank you once again for your help.

Noggin:cool

 

[Ron de Bruin]

Hi

Also what were the double full stops ".."

I posted it with single dots. ??
Maybe a ExcelForum thing

You may want to connect to the MS newsgroups directly.

Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm

David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm

Tushar Mehta's notes at:
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.htm

Or you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)http://groups.google.com/advanced_group_search

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm