I can have the built-in data form open with the workbook with:

Private sub Workbook_Open()
ActiveSheet.ShowDataForm
End Sub

The data form appears to be modal so I can't do anything else
until it is closed. Can I have the event of closing the data form
cause the workbook to be saved and close?

This should do it:

Private sub Workbook_Open()
ActiveSheet.ShowDataForm
Me.Close True
End Sub

"Slim Slender" wrote in message
...
I can have the built-in data form open with the workbook with:

Private sub Workbook_Open()
ActiveSheet.ShowDataForm
End Sub

The data form appears to be modal so I can't do anything else
until it is closed. Can I have the event of closing the data form
cause the workbook to be saved and close?

Try this:

Private sub Workbook_Open()
ActiveSheet.ShowDataForm
ThisWorkbook.Close true
End Sub

On Feb 1, 10:23*am, Slim Slender wrote:
I can have the built-in data form open with the workbook with:

Private sub Workbook_Open()
* * *ActiveSheet.ShowDataForm
End Sub

The data form appears to be modal so I can't do anything else
until it is closed. Can I have the event of closing the data form
cause the workbook to be saved and close?

Thanks guys. Both of those work. But, just one problem.
Be careful what you ask for. It appears that I'll never be
able to do anything with such a file other than use the
data form. I can't get to the sheet or the VBE because
the file closes as soon as the form is dismissed.
Someone at work suggested this to protect a worksheet
form nin-compoops but this ain't the way.

Slim Slender formulated on Tuesday :
Thanks guys. Both of those work. But, just one problem.
Be careful what you ask for. It appears that I'll never be
able to do anything with such a file other than use the
data form. I can't get to the sheet or the VBE because
the file closes as soon as the form is dismissed.
Someone at work suggested this to protect a worksheet
form nin-compoops but this ain't the way.

Can you possibly hide the sheet and use the data form while some other
sheet is active?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

On Feb 1, 9:57*pm, GS wrote:
Slim Slender formulated on Tuesday :

Thanks guys. Both of those work. But, just one problem.
Be careful what you ask for. It appears that I'll never be
able to do anything with such a file other than use the
data form. I can't get to the sheet or the VBE because
the file closes as soon as the form is dismissed.
Someone at work suggested this to protect a worksheet
form nin-compoops but this ain't the way.

Can you possibly hide the sheet and use the data form while some other
sheet is active?

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

That's the ticket!