TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 270
- Office Version
- 365
- Platform
- Windows
Hello, hope someone can help.
We have a file and each row has a hyperlink in column F. Each hyperlink points to a different Word document that is relevant to that particular record.
We have had a number of occasions where the spreadsheet has gone rogue and when Excel recovers it all of the hyperlinks then point to some location on the c: drive (Appdata / Local, just a random location).
The workaround, I think, is to add a button to each cell in column F and have it open the file which will be named in column N.
So rather than have a macro for each button, is it possible to have one macro that will open the right file? So row 2 button might call C:\test1.doc whereas row 9 button might call c:\hello.doc.
Essentially, the macro needs to "know" which of the hundreds of buttons has been pressed.
Hope that makes sense, thank you for reading.
We have a file and each row has a hyperlink in column F. Each hyperlink points to a different Word document that is relevant to that particular record.
We have had a number of occasions where the spreadsheet has gone rogue and when Excel recovers it all of the hyperlinks then point to some location on the c: drive (Appdata / Local, just a random location).
The workaround, I think, is to add a button to each cell in column F and have it open the file which will be named in column N.
So rather than have a macro for each button, is it possible to have one macro that will open the right file? So row 2 button might call C:\test1.doc whereas row 9 button might call c:\hello.doc.
Essentially, the macro needs to "know" which of the hundreds of buttons has been pressed.
Hope that makes sense, thank you for reading.