Then choose ThisWorkbook from the left Project Explorer pane, double click it to open the Module, and then copy and paste following VBA code into the blank Module: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.Ģ. In Excel, we can apply the following VBA code to make the specific worksheet always before your current clicked worksheet tab, so that you can always see this worksheet when you scroll across any other sheet tabs. Lock or freeze a specific worksheet tab with VBA code In fact, there is no direct way for you freeze the tab, but, you can use a workaround to deal with this problem. And now, you want to try to lock or freeze this sheet tab to make it always visible even when scrolling across a number of worksheets. Supposing you have a workbook which contains multiple worksheets, there is a worksheet named Main-sheet as the first tab in the workbook. To freeze the first 4 columns, select column E (the fifth column) and click the magic Freeze button, etc.How to lock or freeze worksheet tab in Excel? Note: to unlock all rows and columns, click the Freeze button again. Scroll down to the rest of the worksheet. To freeze the top row, select row 2 and click the magic Freeze button.ħ. Under Choose commands from, select Commands Not in the Ribbon.Ħ. The orange region above row 3 and to the left of column C is frozen.Īdd the magic Freeze button to the Quick Access Toolbar to freeze the top row, the first column, rows, columns or cells with a single click.ģ. To freeze cells, execute the following steps. Excel automatically adds a dark grey vertical line to indicate that the first four columns are frozen. All columns to the left of column E are frozen. To freeze columns, execute the following steps. Excel automatically adds a dark grey horizontal line to indicate that the first three rows are frozen. On the View tab, in the Window group, click Freeze Panes.Ĥ. To freeze rows, execute the following steps.Ģ. Excel automatically adds a dark grey vertical line to indicate that the first column is frozen. To freeze the first column, execute the following steps. On the View tab, in the Window group, click Freeze Panes. To unlock all rows and columns, execute the following steps.ġ. Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen.
0 kommentar(er)
