sheet object

  1. S

    Unknown/Undeletable VBA Microsoft Excel Object

    Hello, I have a fairly large workbook that uses vba code to add and delete sheets. In reviewing the project explorer, I noticed a few "Sheets" without names (see the picture, sheet24 and sheet25 and there are a few others not seen here). The icon associated with them is similar to the...
  2. S

    Automate creation of event macro

    Hi, So I have a monthly report that I have automated to refresh with new data and perform other preparations. One tool I have will cause the header to change color if filtered. That way I don't forget the filter and allow it to mess up the rest of my work. I want to add the creation of this...
  3. E

    Moving all code to add-in (reference): error when referencing ActiveX controls

    I have a collection of workbooks, each containing monthly data. They rely heavily on VBA functionality, and I'm always making tweaks and improvements. Since I recently found out how to separate out the code into an add-in, it struck me as a great idea to do so for two reasons: 1) Smaller files...

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