I have a basic question. What is a macro? What are they for? Sometimes my computer asks me if I want to disable macros, and I've no friggin clue if I do or don't want to. I tell him to make up his own mind, but he wants me to decide.
OK, I'm not a techie, so I hope I'm clear.
A macro is a tool to simplify tasks that you do all the time.
I work mainly in excel, so I'll speak from that aspect.
There are 2 ways to create a macro, either by recording one, or writing one.
Recording one is easy as pie.
In my example, where I wanted to crop an image...first, without creating a macro, I determined that I needed to crop the image 3 points on the left, 4 points on the right, etc.
ok, so now I know what I want to do....I'm going to call the macro "crop"
With the full orignal image sitting on your excel sheet do the following..
Record New Macro
The window that appears, asks you to name the macro, name it "crop"
Where is says "store macro In" you can choose to just keep it in that workbook (or copies of the workbook if you're using this as a master) or in a Personal Macro Workbook, which makes it available to use anywhere (the personal macro workbook is hidden)
You'll see you can also create a shortcut key.
Now, everything you do, every keystroke, click etc is being recorded. You go ahead and crop your image, resize, everything you want to do with it.
Now, whenever you want to crop a picture like that (like for my 7 days) You click
and choose the one called "crop"
or use your shortcut key.
Both those methods of running a macro are a pain in the ass to me, that's why I put a clip art picture up, and assign the macro to it, like I said in a previous post.
then, when you want to run the macro, you just have to click on that clip art, and it runs.
Try doing that yourself, it's really easy.
Just record, type a bunch of stuff, formate change colors, whatever, then stop recording.
It saves a lot of time once you get the hang of it.
Hey, I just tried it it Word, tying a bunch of garbage, and it works the same way.
If you are constantly having to type a long paragraph, you could assign a macro to do it for you in a instant.
You can also write a macro, or edit it, but that's too much to go into right here.