#1 By: howtogeek, May 14th, 2013 08:00
Originally published at: http://www.howtogeek.com/162975/geek-school-learn-how-to-use-excel-macros-to-automate-tedious-tasks/
One of the more powerful, but seldom used functions of Excel is the ability to very easily create automated tasks and custom logic within macros. Macros provide an ideal way to both save time on predictable, repetitive tasks as well as standardize document formats – many times without having to write a single line of code.
#2 By: 2Noob2BTrue, May 15th, 2013 02:42
To use macros you first need to enable the Developer tab which is disabled by default.
#3 By: moree, May 15th, 2013 05:46
You can do the basics from the View ribbon including running, recording and editing VBA code. When you need to use Form and ActiveX controls you'll need the Developer ribbon.
#4 By: Harisson_Ford, May 23rd, 2013 12:26
So, I am trying to create macroses (which never works), everything is fine with the recording but when I change the sheet and apply the key combination, the macro brings the graph from the 1st (the one I used to record) data sheet.
Here is the case -
I have data on many sub-sheets in a document that is in the same cells.
After I do the first sheet and recorded my actions, I would like to apply the same actions to the other sheets.
#5 By: 2Noob2BTrue, May 26th, 2013 01:33
Oh, I'm using Home and Student 2007 which might explain why all macros were disabled by default.