icnt

  1. D

    Macro buttons on protected worksheet UserInterfaceOnly

    I am working on protecting my workbook but I have many backend macros and macros tied to buttons. Research found that the recommended way to protect worksheets and still allow macros to work is to use the userinterfaceonly = True property. i have been testing each of my worksheets to make sure...
  2. D

    Updating Active-X listfillrange on sheet copied from another workbook causes "We found Problems with some Content" error

    I'm using Excel 2016 and windows 10. Has anyone run into this issue before or have any ideas on what to try to resolve? I have an Excel Application which is very slow in 2016 and 365. My workbook is designed to build a scenario by copying template sheets (In the workbook) and then allowing the...
  3. S

    How to add "if no match found, msgbox: no match found." in this type of code

    This code gives me a report.. but when the product selected in the combobox isn't found it gives me an error, I want it to just end the code and let me make a new search instead of the error. In the code I posted below, where it says: s = Sheets("Menu").ComboBox1 If s = "" Then Exit...

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