Tom, Thanks for your reply. Below is an example of code I'm using as attached to a Command button. What I need in this case is something similar, but without the use of the button. I'm sure your hint would point a programmer in the right direction, but I don't understand it. Could you go further? One thing I forgot to mention, the text appearing in the cell range is put there by a formula in the cell range, like =IF(G17<"","1.1:",""). When the user types information in an adjacent cell, the cell range is populated accordingly. So, the only reason a user has for clicking on the cell range is to move to a different Worksheet, as described in my original post. Any help you can provide is sincerely appreciated. Thanks, Phi

Sub GoToCustomer(
Application.ScreenUpdating = Fals
Sheets("Customer").Selec
Application.Goto Reference:=Range("A1"), Scroll:=Tru
ActiveWindow.Zoom = 6
Application.ScreenUpdating = Tru
End Su