Excel Scrolls Always Down to Barcode Control (V10)

Excel Scrolls Always Down to Barcode Control (V10)

Problem

When opening a document or activating a worksheet, the focus is not on the last selected cell - instead Excel displays the (last) embedded Barcode ActiveX Control.

Workaround (VBA)

The following workaround moves the cursor back to actual selection. Press Ctrl-F11 to open the VBA editor and add the following code:

' Add to Module 1
Sub GoToActualSelection()
Dim myRange As Range
Set myRange = Selection
myRange.Select
End Sub
' Add to Worksheet
Private Sub Worksheet_Activate()
GoToActualSelection
End Sub ' Add to Workbook
Private Sub Workbook_Open()
GoToActualSelection
End Sub

Save your document as Macro-enabled Workbook (XLSM).