Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I prevent a sheet from moving within a workbook?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I prevent a sheet from moving within a workbook?
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I prevent a sheet from moving within a workbook?
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I prevent a sheet from moving within a workbook?
You are correct, so this little mod might be better
Private Sub Workbook_SheetActivate(ByVal Sh As Object) Worksheets("Summary").Move befo=Worksheets(1) Application.EnableEvents = False Sh.Activate Application.EnableEvents = True End Sub Bob "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to prevent data from moving to a different cell | Excel Worksheet Functions | |||
Moving Sheet to Closed Workbook | Excel Discussion (Misc queries) | |||
Prevent users to use a workbook/sheet after a specified day | Excel Worksheet Functions | |||
Can I prevent a sheet from moving within a workbook? | Excel Programming | |||
How to prevent pasting to every sheet in workbook | Excel Programming |