How to use hyperlink for spreadsheet with selected cell?

Asked

Viewed 41 times

0

Look at the picture;

inserir a descrição da imagem aqui

My goal is to click on the mobile the user is directed to the spreadsheet being the line selected, as it is in the image above it is selecting the line manually.

The line of code that needs to change this below, I need help.

=HIPERLINK("#BRG83204D4!A2";"BRG83204D4")
excel

1 answer

0

Within the area of excel developer, run the VBA code by swapping the values for their variables, this can help solve your problem:

Sub test()
 With Worksheets("Sua planilha")
     .Hyperlinks.Add Anchor:=.Range("Sua celula"), _
     Address:="Caminho a ser direcionado", _
     ScreenTip:="Mensagem que ira aparecer ao passar o mouse", _
     TextToDisplay:="Mensagem que ira aparecer na celula"
 End With
End Sub

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.