Data Form

  • Thread starter Thread starter Slim Slender
  • Start date Start date
S

Slim Slender

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
 
Try this:

Private sub Workbook_Open()
ActiveSheet.ShowDataForm
ThisWorkbook.Close true
End Sub
 
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.
Click to expand...

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