How to link the macro enabled file with the original file?

[saranyatl]

HI...
I wrote a code in sheet 1 of Book1_DT.xlsx for checking a cell value and then hyperlink to the corresponding Sheet.

=IF(Sheet1!L41="1,2,3",HYPERLINK("[Book1_DT.xlsx]123!A1","1,2,3"),IF(Sheet1!L41="1,2,5",HYPERLINK("[Book1_DT.xlsx]125!A1","1,2,5"),IF(Sheet1!L41="1,2,4",HYPERLINK("[Book1_DT.xlsx]124!A1","1,2,4"),IF(Sheet1!L41="1,2",HYPERLINK("[Book1_DT.xlsx]12!A1","1,2"),IF(Sheet1!L41="1,2,3,4",HYPERLINK("[Book1_DT.xlsx]1234!A1","1,2,3,4"),IF(Sheet1!L41="1,2,4,5",HYPERLINK("[Book1_DT.xlsx]1245!A1","1,2,4,5"),""))))))

This Code worked perfectly...it checks cell L41 of sheet 1 and depending on the cell value it goes to other sheets named as 123,124,125,12,1234,1245.

Now i added macros in sheet1 and saved it as macro enabled file. After saving as macro enabled file the hyperlink is not working.
Kindly help me to run macro and hyperlink in the same file..

 

[xenou]

Hi,
If you change the name of the file you need to recreate the hyperlinks (xlsx is now xlsm in the filename).
ξ

 

[saranyatl]

Hi,
If you change the name of the file you need to recreate the hyperlinks (xlsx is now xlsm in the filename).
ξ

Thank u...its working perfectly..