Form view available directly on opening workbook.

[The Grim Discovery]

Hello

Is it possible to have the form view appear immediately on opening the workbook? If it is, please tell me how.
To clarify, I'm not talking about a user form but the form function that's available within More Commands.

Currently I've got form available on the QAT and via a Macro but I want others to use the workbook and to input directly into the form rather than keying data into the next row in the asscociated table.

Any of that make sense? Thanks as always.

 

[Micron]

In workbook open event try

Private Sub Workbook_Open()
With Sheets("Sheet8")
     .Select
     .Activate
     .ShowDataForm
End With

End Sub

Change sheet name to suit. Took me about 30 minutes to figure that out. From the start I didn't even know what you were on about regarding this kind of form.