I don't think that works, Bob; it makes the summary sheet active. I think
the OP wants the Summary sheet tab to be visible as the leftmost one on the
bottom even when Sheet99 is active.

Regards,

Vasant


"Bob Phillips" wrote in message
...
A bit of a fudge, but you could always add this to the ThisWorkbook code
module. I am assuming that the workhseet is called Summary.

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Worksheets("Summary").Move befo=Worksheets(1)
End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
AFAIK, no.

--

Vasant

"JDGUILTY" wrote in message
...
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.