Hi Dianne
Not sure what you mean exactly.
When performing regular tasks, it is easier to record a macro and then
run it (from "Tools/Macro/Macro's") each time that it is needed, rather
than do the task(s) manually each time.
Having said that however, there are simpler methods of launching
macro's.
1. It is possible to connect a macro to a button which can be placed
onto the spreadsheet.
- Record the Macro using "Tools/Macro/Record Macro"
- Now add a button to the form using "View / Toolbars / Form"
- Link the button to the macro.
- Each time that you click the button, the macro will run.
2. You are also able to create a form (like a dialogue box) and link a
macro to a button on the form.
I use Method 1 when little/no input is required from the user. (EG :
Sort information, Total amounts, Print a report and then restore that
data back to the format that it was in.)
I use Method 2 for more complex procedures.
For Example, In WORD am currently working on converting RTF files to
HTML so that they can be displayed with a Macromedia SWF viewer. The
problem is that the viewer on recognises some HTML tag and I can
therefore not just "Save As" to HTML format.
I have created a User Form that asks the user
a. The path to the RTf files.
b. The font size that must be applied.
c. The foreground & background colours that must be applied.
d. Whether docs must be "Spelling & Grammar" checked before they are
converted.
Once the user completes all of this criteria, they click on an "OK"
button. This button then launched the macro which processes the the
content and saves it as an HTML file.
Hope this answers some of the questions that you have.
Also take a look at
http://www.mrexcel.com and see the "challenge of
the month" section - You will be astounded what excel can do!
