View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Can I prevent a sheet from moving within a workbook?

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.