View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Range Acting Lke Control?

Hi

I suggest you make a hyperlink of the text (insert menu). Use the workbook
even
Workbook_SheetFollowHyperlink
if you need additional code running (like zoom)

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Phil Hageman" skrev i melding
...
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?