View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Ramage[_3_] Dave Ramage[_3_] is offline
external usenet poster
 
Posts: 8
Default Range Acting Lke Control?

Add this tot he worksheet module of the required worksheet
(right-clcik the worksheet tab an select View Code)

Private Sub Worksheet_SelectionChange( _
ByVal Target As Range)
If Target.Address = "$C$12:$Z$16" Then
Sheets("Customer").Activate
Sheets("Customer").Range("a1").Select
ActiveWindow.Zoom = 62
End If
End Sub

Note that this code will run every time the selection
changes on the worksheet, though this shouldn't slow
things down by any perceivable amount...

Cheers,
Dave

-----Original Message-----
Range C12:Z16 is merged, with typed text. Is it possible
to make this merged range operate the same as a forms
control button, such that if clicked on, the user is

taken
to worksheet "Customer", Screen is sized (Zoom) to 62,
Cell "A1" selected? A forms control button is very
unsightly, and somewhat confusing - there are other
buttons working on the same screen.

Would the range, and text in the range, be created by

code?
.