VBA Code for Edit links in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1322468%22%20slang%3D%22en-US%22%3EVBA%20Code%20for%20Edit%20links%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1322468%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3ECould%20someone%20please%20help%20me%20with%20the%20code%20of%20Edit%20links%20in%20Excel%20in%20VBA%2Cbecause%20every%20month%20I%20have%20to%20change%20the%20link%20manually%20and%20its%20very%20time%20consuming%20activity.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3ERoshan%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1322468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1323319%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%20Code%20for%20Edit%20links%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1323319%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F523429%22%20target%3D%22_blank%22%3E%40Roshan_K%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20depends%20on%20what%20type%20of%20change%20you%20want%20to%20apply.%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20change%20the%20link%20name%2C%20check%20out%20this%20%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F47452637%2Fexcel-vba-macro-change-link-name%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EQ%26amp%3BA%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor
Hi,

Could someone please help me with the code of Edit links in Excel in VBA,because every month I have to change the link manually and its very time consuming activity.

Thanks
Roshan
1 Reply
Highlighted

@Roshan_K

 

Hi,

 

It depends on what type of change you want to apply.

If you want to change the link name, check out this Q&A.

 

Regards