So your new workbook needs some navigation links. You may want to use hyperlinks, because most people are familiar with them, thanks to the internet, but they create a couple of little problems we need to solve. The example workbook here ( Hyperlinks.xls ) illustrates these problems and their solutions...
I'm interested in practical techniques and tools which can be used every day to make business users more effective, and that's what this blog will be about. The topics will not just be technical (eg the best use of worksheet functions), but will also cover things like creating a professional...