Excel2PPT
Get Excel2PPTSupport
  • πŸ‘‹Welcome to the Excel2PPT Exporter
  • πŸ’‘Fundamentals
    • Getting Started
    • Support
  • πŸ“šGuides
    • How to Retrieve and Fill in Image Properties (Width, Height, Top, Left)
    • How to Access additional Settings
    • How to Customize addtional Settings
    • How to Use the Clean PowerPoint File Button
    • How to Define Named Ranges for Export
    • How to Use the Insert Template Button
  • ⁉️FAQ
    • I don’t know VBA. Can I still use this template?
    • Can I export ranges that are not charts?
    • Can I view and edit the VBA code?
    • Can I change the position and size of the charts in PowerPoint?
    • Can I place multiple charts on a single slide?
    • Which Excel versions are supported?
    • How do I get a refund?
Powered by GitBook
On this page

Was this helpful?

  1. Guides

How to Access additional Settings

Last updated 6 months ago

Was this helpful?

To customize the settings of the Excel2PPT utility, you need to access the SETTINGS module in the Visual Basic for Applications (VBA) editor. Follow these steps to open and modify the settings:

  1. Enable the Developer Tab

    • If you do not see the Developer tab in Excel, right-click on the ribbon and select Customize the Ribbon.

    • Check the box next to Developer and click OK. This will make the Developer tab visible in your Excel ribbon.

  2. Open the VBA Editor

    • Go to the Developer tab and click on Visual Basic.

    • Alternatively, press ALT + F11 to open the VBA editor directly.

  3. Navigate to the mSettings Module

    • In the VBA editor, locate your workbook under VBAProject.

    • Expand the workbook and navigate to Modules.

    • Double-click on the module named mSettings to open it.

  4. Modify the Settings

    • Once you have opened the mSettings module, you will see a list of configurable settings.

    • You can adjust these values to customize how the Excel2PPT tool functions.

For a more detailed explanation of each setting, please refer to the Customization Guide.

πŸ“š