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?
I don't think you can do what you ask. A work-around would be to put the
"lookup" worksheet immediately to the left of the selected worksheet. Since you're using a drop-down, you're obviously capturing the name of the selected worksheet. Put the following syntax (adjusting for your own variables and worksheet names) in the code that activates your selected worksheet. Sheets("MyLookupWorksheet").Move befo=Sheets(strSelectedWorksheet) HTH, Gary Brown "JDGUILTY" wrote: 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 | |||
how do i prevent a row from moving, like subheader that is visibl | New Users to Excel | |||
Moving Sheet to Closed Workbook | Excel Discussion (Misc queries) | |||
Prevent users to use a workbook/sheet after a specified day | Excel Worksheet Functions | |||
How to prevent pasting to every sheet in workbook | Excel Programming |