September 22, 2021

Open Specific Worksheet at Specific Location on Opening Workbook

How to open a specific worksheet at a specific location automatically when the Excel workbook opens using VBA. Watch the video below:

Open Specific Worksheet at Specific Location on Opening Workbook

When we open a workbook with multiple worksheets then only the worksheet and the range or cell location opens which were selected before closing. Now what if we wish to always open a specific worksheet at a specific location no matter how we closed the workbook? We can achieve this automation in Excel using the following code:

Private Sub Workbook_Open()
Worksheets(“DataEntry”).Activate
Dim lastrow As Long
lastrow = Application.WorksheetFunction.CountA(Range(“A:A”))
lastrow = lastrow + 1
Range(“A” & lastrow).Activate

End Sub

What is the advantage of such an automation? The major advantage is time saving because we wish to continue our data entry where we left off without having to search for the relevant worksheet.

Open Specific Worksheet at Specific Location on Opening Workbook using VBA

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.