Skip to content
Skip to content
Menu
Alchemex
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Alchemex

Easy steps to opening an Excel workbook on a specific worksheet

By admin on May 27, 2016April 19, 2019

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.
Follow these easy steps below as we explain how this can be done. 
Applies To: Excel 2003, 2007, 2010, 2013, 2016
Visual Basic Coding: 
Private Sub Workbook_Open()
Sheets(“Sheet1”).Select
Range(“A1”).Select
End Sub 
Open Microsoft Excel, then press Alt + F11 (This will open the VISUAL BASIC Editor).
On the far left, under Microsoft Excel Object, select ThisWorkbook.
Then on the right hand side, paste the above code.
In the second line of the code, change Sheet1, to the sheet name (tab) you wish to land on.

7.  In the third line of the coding, change A1, to the cell you wish to land on.
8.  From the Menu bar, select File, Close and Return to Microsoft Excel, then save and close the Microsoft Excel workbook.
10.  Ensure you save the workbook as an Excel Macro-Enabled Workbook (*.xlsm)
The next time you open the workbook, it will open on the specific worksheet and cell
N.B Ensure that your Macro Settings are not disabled under the Macro Settings Option . To set your Macro security level, follow the steps below:
On the Office/File tab, select Options.
On the left side of the dialogue box,select Trust Centre, then select the Trust Centre Settings button.
On the left side, select Macro Settings, then select Disable all macros with notification.
By 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.
 
The post Easy steps to opening an Excel workbook on a specific worksheet appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

Three ways to achieve the same result in Sage Intelligence Reporting
Learn a better way to visualize your data using the Bing Map app in Excel

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600
©2025 Alchemex | WordPress Theme by SuperbThemes.com