Excel Magic Trick #46: Absolute Macro Recorder

May 31, 2009 | By admin In Videos |

Se­e­ ho­w­ t­o­ cr­e­at­e­ an Ab­so­lut­e­ M­acr­o­ (VB­A co­de­) usi­ng t­he­ M­acr­o­ R­e­co­r­de­r­. Se­e­ ho­w­ t­o­ add t­he­ De­ve­lo­pe­r­ R­i­b­b­o­n i­n E­xce­l 2007. Le­ar­n ho­w­ t­o­ use­ Alt­ + F8 t­o­ se­e­ M­acr­o­ li­st­. Se­e­ ho­w­ t­o­ save­ a M­acr­o­ i­n t­he­ hi­dde­n Pe­r­so­nal W­o­r­k­b­o­o­k­. Se­e­ ho­w­ t­o­ hi­de­ and unhi­de­ t­he­ Pe­r­so­nal W­o­r­k­b­o­o­k­. Fo­r­m­at­ a R­e­po­r­t­ w­i­t­h a M­acr­o­.

Other Related Posts:

9 Comments so far

  1. Anonymous on May 31st, 2009

    DrSobell,
    Solution: Make sure you installed Visual Basic for Applications, It is under Office Shared Features when you install the software, just put your Microsoft office 2007disc back in & Click Add or Remove Programmes. Go to Office Shared Features & click run from my computer, you are then good to go.Alot off people have this problem when they custom install the Software, Hope this helps

  2. Anonymous on May 31st, 2009

    Dear shiryu008,

    Yes, Macros are not that easy. I am not very good with writing VBA code by hand. I only have 4 videos about Macros (Macro recorder). You can see them all in the Macro Playlist.

    –ExcelIsFun

  3. Anonymous on May 31st, 2009

    dealing with macros is not so simple as i see. i was courious to understand how does it works.
    My rating? you type =vlookup(excellsfun;mike;are awesome;0).
    chao mike.

  4. Anonymous on May 31st, 2009

    Dear DrSobell,

    EXCELlent!!! Everytime I make a chart in Excel 2007, I wish that I could use Excel 2003 (it is much faster).

    –ExcelIsFun

  5. Anonymous on May 31st, 2009

    Couldn’t figure it out, so went back to 2003… btw your videos are excellent thanks for all your informative videos, you make picking up Excel so much easier! :)

  6. Anonymous on May 31st, 2009

    Dear DrSobell,

    I have not encountered this problem. I just tried to duplicate the problem in one of my spreadsheets (options and security), but I cannot duplicate it. You should go to the Discussion Board at the MrExcel web site. The smartest Excel people in the world love to answer questions. If any groups of people have a chance of already seeing this problem, it is this group!

    –ExcelIsFun

  7. Anonymous on May 31st, 2009

    Hi having a problem… the Record Macro and VBA buttons under the developers tab are unabled and cant be selected?? Ive ensured that the developers tab is showing, the file extenstion is either .xls or .xlsm macro enabled & in the macro security all macros and VBA are enabled?? any thoughts?

  8. Anonymous on May 31st, 2009

    Dear periwink,

    I hope when you show off your new tricks to your boss, he gives you 7 stars!!

    –ExcelIsFun

  9. Anonymous on May 31st, 2009

    5 stars :) .

Leave a reply

Spam Protection by WP-SpamFree