View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Excel Form Question

hi
from an old post by Tom Hutchins.......
You can hide Excel so only your userform is showing.

To hide Excel when the form as activated:
Private Sub UserForm_Activate()
'Hide Excel when this form is activated
Application.Visible = False
End Sub

To show Excel again when the form is unloaded (In this example, the code is
attached to a command button on the form).
Private Sub cmdExit_Click()
'Close the form and show Excel.
Unload Me
Application.Visible = True
End Sub

and i suppose that you will have other code to go with the form.
just be sure to unhide excel when you close your form.

regards
FSt1

"General Fear" wrote:



I wanted to create a form using Excel. The form example that I have
seen shows the Excel Spreadsheet in the background.

Is it possible to create a form that will not show Excel at all?
Basically, what I wanted to create is a form with no Excel menus or
Excel cells. All I want the user to see is the form, with no hint of
Excel. That way, the end user will not realize that they are using
Excel at all.

If I can do the above, is there an example on the Net that I can
download and examine. Otherwise maybe you all can tell me how to do
this.