Enable design mode in a jets report

Copper Contributor

In a jets report developer tab the design mode is dim. How to get the design mode enabled is the question.


1 Reply


In Excel 365, the process for enabling Design Mode in the Developer tab is generally the same as in older versions of Excel. However, the exact steps can vary depending on the specific context and what you are trying to achieve. Here are the general steps to enable Design Mode in Excel 365:

  1. Open Excel 365:
    • Launch Excel 365 and open the workbook you want to work with.
  2. Enable the Developer Tab:
    • If you do not see the Developer tab on the Excel ribbon, you will need to enable it first. Here is how:
      • Click on "File."
      • Go to "Options."
      • In the Excel Options window, select "Customize Ribbon" on the left sidebar.
      • In the right pane, check the box for "Developer" in the list of tabs.
      • Click "OK" to save the changes.
  3. Add an ActiveX Control (Optional):
    • If you intend to work with ActiveX controls, you will need to add one to your worksheet. To do this:
      • Go to the Developer tab (which should now be visible).
      • In the "Controls" group, click "Insert."
      • Select the ActiveX control you want to use (e.g., Button, Checkbox, etc.).
      • Click and drag on the worksheet to draw the control.
  4. Enable Design Mode:
    • After you've added an ActiveX control (if necessary), you can enable Design Mode:
      • Go to the Developer tab.
      • In the "Controls" group, click the "Design Mode" button. This will allow you to interact with the controls and make design changes.
      • The button should turn orange when Design Mode is enabled.
  5. Make Design Changes:
    • While in Design Mode, you can move, resize, or configure ActiveX controls as needed. You can also make other design changes to your worksheet.
  6. Exit Design Mode:
    • When you are done making design changes, you can exit Design Mode by clicking the "Design Mode" button again. It should return to its normal appearance, and you can use the controls you have added.

Remember that Design Mode is primarily used when working with ActiveX controls and form-related tasks in Excel. If you are encountering specific issues with Design Mode not working as expected in Excel 365, it might be helpful to provide more details about the problem or any error messages you are encountering so that I can provide more targeted assistance.

My knowledge of this topic is limited, but since no one has answered, I entered your question in various AI. The text and the steps are the result of various AI's put together.


My answers are voluntary and without guarantee!


Hope this will help you.

Was the answer useful? Mark them as helpful and like it!

This will help all forum participants.