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?
.
|