Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro's
In layman's terms, what is a macro? can you make them for just about
anything? and how do you make one? (I get all the way to the part where you click on record macro, then I am dumbfounded). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro's
I am not that familiar with macros but I use them for like sorting
information or refreshing all pivot tables and stuff like that but once you start recording a macro, it will record every single thing you do like if you copy and paste something it will copy your moves. To stop recording you go to tools, macro, and then stop recording. To use your macro you insert like a button from forms, or you can just insert like rectangle or circle and right click on it to assign the macro, and once you have done that it will act as a button and the macro will do whatever you recorded it to do. "mmassey" wrote: In layman's terms, what is a macro? can you make them for just about anything? and how do you make one? (I get all the way to the part where you click on record macro, then I am dumbfounded). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro's
A macro is a piece of programming code that makes a computer do things. Most
often a macro helps the user with - boring, time consuming, silly tasks - tasks too big to do manually - tasks too complex to do manually I write my macros. It's just a language (Visual Basic 6). One needs to know the language and the object one writes it for (here Excel). Yes, you can do about anything with a macro. Best wishes Harald "mmassey" wrote in message ... In layman's terms, what is a macro? can you make them for just about anything? and how do you make one? (I get all the way to the part where you click on record macro, then I am dumbfounded). |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro's
Alright, so can i make a macro for any excel function?
"Pokey" wrote: I am not that familiar with macros but I use them for like sorting information or refreshing all pivot tables and stuff like that but once you start recording a macro, it will record every single thing you do like if you copy and paste something it will copy your moves. To stop recording you go to tools, macro, and then stop recording. To use your macro you insert like a button from forms, or you can just insert like rectangle or circle and right click on it to assign the macro, and once you have done that it will act as a button and the macro will do whatever you recorded it to do. "mmassey" wrote: In layman's terms, what is a macro? can you make them for just about anything? and how do you make one? (I get all the way to the part where you click on record macro, then I am dumbfounded). |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro's
These pages may help, good luck.
http://www.mvps.org/dmcritchie/excel/getstarted.htm http://blog.contextures.com/archives...n-vba-machine/ http://www.bettersolutions.com/excel...R646543531.htm "mmassey" wrote in message ... In layman's terms, what is a macro? can you make them for just about anything? and how do you make one? (I get all the way to the part where you click on record macro, then I am dumbfounded). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
running macro's in Excel 2007 | Excel Worksheet Functions | |||
How can i create macro's in Excel? | Excel Discussion (Misc queries) | |||
Excel macro's to run at a scheduled time | Excel Discussion (Misc queries) | |||
Excel macro's deleted when sending through Outlook | Excel Discussion (Misc queries) | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) |