Automatically open with a form in Excel 1

[melt333]

Hi,

I am trying to create an excel workbook to automatically open with a form (without a worksheet behind it). At the moment I have a button on the worksheet which opens the form for me, but I am not happy with that. I've read about the workbookopen event, but where does the procedure go, and how do you code it to open the form. I have tried using the code:

Private Sub App_WorkbookOpen(ByVal Wb As Workbook)
Load frmProcess (frmProcess being the name of the form?!?!)
frmProcess.Show
End Sub

in the 'ThisWorkbook' module, to no avail - nothing happens.

PLEASE HELP!!!

In advance, your help is much appreciated

 

[xlbo]

To get to the workbook open event, go to the VB Editor and within your project, double click on "This Workbook"
Choose "Workbook" from the left side dropdown. It should then place a workbook open sub there by default (but with no code)

Within that sub, place the following:

application.visible = false
frmProcess.Show

so your entire sub would look like this:

Private Sub Workbook_Open()
application.visible = false
frmProcess.Show
End Sub

This will show the form with no worksheet (well no excel to tell the truth) but you have to be very careful and make sure that there is a button on the form that has application.visible = true otherwise there will be an excel program running invisibly

If you just want a blank view behind and don't want to hide excel, I would suggest that you just use a blank worksheet, colour it white and turn off gridlines

HTH Rgds
~Geoff~

 

[melt333]

Excellent! So easy, when you know how?!?!

Thank you very much,

Mark