MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel Record Macro Examples

  Asked By: Nicole    Date: Sep 30    Category: MS Office    Views: 1238

I need some examples in excel using the Record Macro Facilty in
excel . I need to screen capture the code generated out of it and put
it in my assignment.

Can Anybody help me ut with it as it is due tomorrow.



3 Answers Found

Answer #1    Answered By: Stacie Martin     Answered On: Sep 30

Record some macro  (select the option Store Macro in: This workbook}. After
you have recorded the macro, Press ALT+F8. Window with Names of Recorded
Macros will appear. Select the macro and press Edit button.

Window with recorded code  will appear. You may copy paste the generated  code
of Press "Print Screen" key to capture  the screen  shot.

Answer #2    Answered By: Adali Fischer     Answered On: Sep 30

I think the best way to do this is to make sure you can see the code  on the
screen. Then hit the "print screen" button to copy to the clipboard. use a
grpahics editors like photoshop or paint to crop the image to what you need and
then print it out.

Answer #3    Answered By: Olga Kates     Answered On: Sep 30

You may want to adjust things a bit as well. If you close all the
windows including the project tree *except for the code  window and
then unmaximise it, you can adjust the window to have a nice view of
the code and then hit Alt Prntscrn, not just Prntscrn. This will copy
the active window to the clipboard.

Didn't find what you were looking for? Find more on Excel Record Macro Examples Or get search suggestion and latest updates.