View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Hageman[_3_] Phil Hageman[_3_] is offline
external usenet poster
 
Posts: 160
Default Control Button Clone

In worksheet "Scorecard", six cells (E17:F19) are merged with text typed in (formatted text). Is there a way with VBA that when the user clicks on the merged cell range they are moved to worksheet "Customer", with cell A65 positioned at the top left corner? Inserting a control button with an attached macro is not allowed in this case.