Data entry forms

C

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?
 
B

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
 
Top