View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default Validation and application size

Hi Pierre,
Right click the SheetTabView Code then copy this into that Sheet's
Code Module:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Column < 4 Then Exit Sub
Range("D1").Copy
ActiveCell.PasteSpecial Paste:=xlPasteAll
End Sub

Ken Johnson