I want to know if there is a way to "freeze" a worksheet like you can
freeze/unfreeze panes on a worksheet. I have an Excel workbook that is
comprised of approximately fifty worksheets. I use the first worksheet as a
"lookup" worksheet, whereby the user can select a particular worksheet name
from a dropdown list, and then click a button that will take them directly to
the worksheet they picked. I want to be able to keep the "lookup" worksheet
static in its place, whereby it will always be on the left-most position of
the worksheet tabs at the bottom of the workbook.