automatically run code

  1. R

    Copying a button from one sheet to automatically run code when copied to new sheet.

    Hi I am struggling with getting a macro to run when I create a new button on a sheet. I assign the On Action to the button and the macro runs without debug, but... the OnAction doesn't run the Macro "Test". The Button being copied to Sheet2 is on Sheet1, then the Macro should automatically run...
  2. T

    VBA Macro to auto run on open and close with formatting

    Hi, I am trying to keep column G as text format. I would not like anyone to change the format as another program needs to read it as text. so the format has to be for ex. 12/22/2014 or 12/01/2014 but text and users should not be allowed to change it. What i had so far is not working, can...
  3. craig.penny

    Run a macro after the security setting is lowered

    Hi all, I have a macro with a lot of hotkeys that are set in the "WorkBook_Open" event code but many people get it and need to turn thier security settings down so they can run any macros. That is, none of the hotkeys will be set since that event code didn't run. Is there any method to...

Watch MrExcel Video

This Week's Hot Topics

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
Top