where is the excel object library in office 365

Dman60 0 Reputation points
2023-07-13T12:03:21.66+00:00

Where is the excel object library located in office 365 ?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,142 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,226 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Tanay Prasad 2,140 Reputation points
    2023-07-14T05:22:23.1633333+00:00

    Hi,

    You must enable the Developer Tab and VBA Editor in Excel in order to access the Excel object library in Office 365. Here is how you can do it:

    1. Launch Excel.
    2. On the ribbon, select the "File" menu.
    3. From the menu on the left, select "Options".
    4. Choose "Customise Ribbon" from the left-hand menu in the Excel Options window.
    5. Check the "Developer" box under "Customise the Ribbon" in the right-hand side pane.
    6. Click "OK".

    Once you have enabled the Developer tab, you can access the Visual Basic for Applications editor by clicking on the "Developer" tab in the Excel ribbon and then selecting "Visual Basic" from the "Code" group.

    In the VBA Editor, you can access the Excel object library, which contains objects like Workbook, Worksheet, Range, and more.

    Best Regards.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.