Thread: How to 'Click and then perform action'
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chris100[_22_] chris100[_22_] is offline
external usenet poster
  
Posts: 1
Default How to 'Click and then perform action'

Thanks guys but i think i didn't make myself clear. I wanted to have
two cells that zoom in and out on the same sheet but in different
places. I figured it out with the basics you gave me before - or i
needed was an ElseIf. Doh!

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$C$7:$E$7" Then
ActiveWindow.Zoom = 110
ElseIf Target.Address = "$B$61:$C$61" Then
ActiveWindow.Zoom = 110
Else: ActiveWindow.Zoom = 40
End If
End Sub

Thanks for the input guys and gals.


--
chris100
------------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=388140

Reply With QuoteReply With Quote