So before locking a worksheet, make sure that. As mentioned above, cell locking doesnt go into effect until the worksheet is protected. Then dont forget to protect the worksheet as explained below.
Since Excel is so easy to learn and use, as you. It’s used when you need to calculate, analyze and assess data. Individual zoom setting for each worksheet may be accommodated but I thought a loop with a single zoom level would be easiest to get started. Non-contiguous cells can be locked in one step by pressing and holding the CTRL key while selecting the individual cells. Microsoft Excel is an electronic spreadsheet and part of the Microsoft Office suite. For example, to freeze the top row and first column, select cell B2, go to the View tab and click Freeze Panes under Freeze Panes: In the same fashion, you can freeze as many Excel panes as you want. When you reopen the workbook all individual workbook zoom levels will be reset to the level you noted. To lock several rows and columns at a time, select a cell below the last row and to the right of the last column you want to freeze. Save your workbook as either a Macro-enabled workbook (e.g.XLSM) or Excel Binary workbook (.XLSB). Click on Format Cells, which triggers this screen: Select the Protection tab and place a check in the Locked box.
Select Object from the Format menu, click on the Protection tab, and check or uncheck the Locked checkbox. Selecting the chart object displays white handles (small resizing squares around the chart) rather than black handles. Highlight the cells containing the formula and right-click to display the screenshot shown at left. To change the Locked status of the chart, hold the Shift key while clicking on the chart to select the chart object. Tap Alt+ Q to return to your worksheet(s).Ĭhange the individual worksheet zoom level to something you consider atrocious. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company. However, if you want to be sure a user can’t peek at the numbers by erasing the formulas, there is a way to protect them. Private Sub Workbook_Open()Īdjust the zoom level in ActiveWindow.Zoom = 80 to suit your own purposes. This should open a new pane to the right titled something like Book.xlsm - ThisWorkbook (Code). If it is not available, you can open it with View ► Project Explorer or Ctrl+ R. Tap Alt+ F11 and when the VBE opens, look to the Project Explorer in the upper left.
Allowing them zoom functionality while resetting each worksheet's zoom factors for other users seems a comfortable compromise. Removing zoom functionality altogether for the duration of any editing session could lead to errors that could have been avoided if a user was able to zoom into the worksheet to verify something. It might be best to reset the zoom factors each time the workbook is opened.