In an Excel file with lots of worksheets, how do you help users navigate through the workbook? Here are a few of the methods I’ve used. I’m sure you’ve found your own creative ways to deal with the problem, and I’d be interested in hearing about them.
Create a Workbook Menu
You can use programming to create [...]