Selecting Cells
When a user is in cell K10 (merged cells going to V10) and tabs, I would like
it to go to A15. Anyone know the code behind this. The code below is what I
have stated in ThisWorkbook Code, but still doesn't eliminate the user from
going past K10? Any help would be appreciated. Thanks
Private Sub Workbook_SheetActivate(ByVal sh As Object)
With ActiveSheet
.ScrollArea = "A1:V96"
End With
End Sub
|