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...
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...
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...
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.