design mode

  1. brendalpzm

    How to change EMBED name of an ActiveX Combo Box?

    Hello everyone, I inserted several ActiveX combo boxes in a sheet, I figured out a way to reset those combo boxes with a macro button, the thing is that I thought I was only reseting one but instead I was reseting them all (which I don't want) I checked what was I doing wrong and in the code...
  2. D

    Macros in 2011/6 xlsm disabled on another computer with 2007 despite trusted location & macros enabled

    I have a macro enabled xlsm spreadsheet created in Excel 2011, and following a software update to Office 2016 last opened & saved in that. Finding myself now working from home due to Covid, I emailed myself the file to continue working at home (where I have Excel 2007) to develope this further...
  3. M

    VBA Behavior when a Query is refreshed.

    When I have a query running in the background in excel, and I am editing the code I have by entering the following text: In the image above, I am adding text as "cannot go to 1" while a query is running in the background. However, as I am writing the text, there appears to have no spaces in...
  4. H

    Design mode fail

    Hi everyone, design mode used to work when I inserted ActiveX controls. However, today when I tried to use it, the button is greyed out. Listed a screen shot below. Any ideas as to what's going on? Thanks for your help!
  5. J

    Excel 2007 Automatically Turning on Design Mode When Saving and Exiting

    Ok, I have a weekly revenue report that several managers must complete each week. It uses command buttons to guide them through it with userforms. Long story short, 2 managers are using Excel 2007 and it keeps turning on design mode when they save it and exit. Some things I've done: Saved...
  6. dageci

    Design Mode Change Event

    Hello guys/girls, does anyone know any tip (or maybe even the event) on how to detect inside the VBA when the user switches the Design Mode On/Off?
  7. R

    Macro stops in middle - jumps to VB design mode

    here's the macro: Windows("WB1.xlsm").Activate Range("A1").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Range(Selection, Selection.End(xlUp)).Select Selection.Copy Workbooks.Open Filename:= _ "WB2.xlsm" ' ActiveWindow.ScrollWorkbookTabs...
  8. J

    Won't stay in Design Mode

    When I click on the DesignMode icon, it flashes & immediately returns to normal mode. Further symptom: 2x per second flashing of the title bar on the VBE window. VBA seems to be switching from the selected module to something else that flashes by too fast to see. Similar behavior occurs...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top