Recording A Macro

rockyw

Well-known Member
Joined
Dec 26, 2010
Messages
1,196
Office Version
  1. 2010
Platform
  1. Windows
If I try to record a macro, it says it records it, but it does nothing when I run it. I and clicking 2 command buttons and save, But then when I run it nothing happens? Should'nt a macro do what ever I do, then repeat it? Thanks
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Some things record - some don't.
Did it create any VBA code?
 
Upvote 0
I am tring to update the workbook with the sacurity ribbon at the top, then click a command button for a differant macro, then save. Can a marco do this?
 
Upvote 0
What I really want in the end is a macro that will do these 3 things and work off a timer once a day. Maybe do this each day at 2:00am. Can this be done? Thanks
 
Upvote 0
After you stop the recorder:
press Alt + F11
press Ctrl + R

On the left locate your file name.
Below that find Modules Folder
Click + to open Modules Folder

Double Click Module1 (could be multiple modules ie, Module2, Module3 etc)

Your Recorded code (if any) will be there.

If what you want to happen is not there, then it can't be recorded and will have to be coded manually. And yes you can prob create code to do what you want though I still don't understand exactly what that is.

For timers see:
http://www.cpearson.com/Excel/OnTime.aspx
 
Upvote 0

Forum statistics

Threads
1,224,520
Messages
6,179,270
Members
452,902
Latest member
Knuddeluff

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