Thread: Selecting Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LRay67 LRay67 is offline
external usenet poster
 
Posts: 49
Default 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