Using a cell to open an existing worksheet in Excel
Posted on 2011-03-14
Is there a way that when a user would click on a cell, that it could open an existing worksheet within the same file? Instead of having the user find the correct worksheet, a master list could be created and displayed, and then the user would just 'click' the one they wanted? If so, how could it be done. If not, thanks for letting me know.