RSS Feed

Syndicate content

Sono nella cella A1 e nella cella B4 ho un collegamento ipertestuale al sito del Corriere della sera. Eseguendo la macro vorrei passare alla cella B4 e dare il comando di apertura del collegamento ipertestuale.

Submitted by Anonimo on Fri, 21/11/2008 - 15:27

La macro è molto semplice:


Sub apri_link()
'
' Macro2 Macro
' Macro recorded 21/11/2008 by Andrea Terzaghi
'
'
Range("B4").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End Sub

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <style> <center> <p>
  • Lines and paragraphs break automatically.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Copy the characters (respecting upper/lower case) from the image.

Custom Search