On the left side, select Macro Settings, then select Disable all macros with notification.īy landing on a specific worksheet and or cell, you will time by navigating to a desired location within your Excel workbook, thus making streamlining your process and making it more efficient.On the left side of the dialogue box,select Trust Centre, then select the Trust Centre Settings button.On the Office/File tab, select Options.From the Info pane, click the Protect Workbook command. To protect your workbook: Click the File tab to access Backstage view. There are many different ways to protect a workbook, depending on your needs. To set your Macro security level, follow the steps below: By default, anyone with access to your workbook will be able to open, copy, and edit its content unless you protect it.

N.B Ensure that your Macro Settings are not disabled under the Macro Settings Option. The next time you open the workbook, it will open on the specific worksheet and cell Ensure you save the workbook as an Excel Macro-Enabled Workbook (*.xlsm) From the Menu bar, select File, Close and Return to Microsoft Excel, then save and close the Microsoft Excel workbook.ġ0. In the third line of the coding, change A1, to the cell you wish to land on.Ĩ.

In the second line of the code, change Sheet1, to the sheet name (tab) you wish to land on.ħ.

Then on the right hand side, paste the above code.

On the far left, under Microsoft Excel Object, select ThisWorkbook.Open Microsoft Excel, then press Alt + F11 (This will open the VISUAL BASIC Editor).Assuming you have one frequently used Microsoft ® Excel ® worksheet in a big workbook, wouldn’t you prefer to land on that specific worksheet when opening the workbook? By creating the simple macro given below, one can land on a specific Excel worksheet and even a specific cell when opening a workbook.įollow these easy steps below as we explain how this can be done.Īpplies To: Excel 2003, 2007, 2010, 2013, and 2016

Open personal macro workbook excel 2016