Data entry forms

[Colin Smalley]

How do I assign a data entry form to open in a home worksheet rather than
the worksheet that contains all the information?

 

[Bernie Deitrick]

Colin,

You can use the workbook open event to select a specific sheet when the
workbook is opened. For example, if your sheet name is "Home Sheet", this
code, when placed in the codemodule of the ThisWorkbook object of the
workbook, will always ensure that that sheet is selected - if the macros are
enabled when the workbook is opened.

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Home Sheet").Select
End Sub

HTH,
Bernie
MS Excel MVP