I have been browisng through the samples.xls files that installs with Office XP and was wondering how they made the hyperlinks to open the VBE and show the code for a specific procedure. I have tried anything, but cannot
I have a lot of hyperlinks within an Excel spreadsheet. I'm wishing to be able to automate the process of checking each hyperlink (for any broken links) and create a report. Can anyone explain if this is possible or how to do this?
We a planning a big data migration. One big problem we have is that we have hundreds of spread sheets with embedded links that unc paths to other spraed sheets.