Excel Magic Trick #46: Absolute Macro Recorder

Tags:
Absolute Colleges Community Developer Excel Gel Girvin Hidden Highline Macro Mike Personal Recorder Ribbon Workbook
ExcelIsFun
  • Affiliate Submitter:
    ExcelIsFun
  • International International
  • Comments: 0
  • Views: 307
  • Added: 08-Apr-08

See how to create an Absolute Macro (VBA code) using the Macro Recorder. See how to add the Developer Ribbon in Excel 2007. Learn how to use Alt + F8 to see Macro list. See how to save a Macro in the hidden Personal Workbook. See how to hide and unhide the Personal Workbook.

  1. Categories: Science & Tech
Comments on

Excel Magic Trick #46: Absolute Macro Recorder

9 Comments | Add Comment
  • DrSobell, Solution ...

    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

    By b19ully [Affiliate User] 1220977161 Reply Spam Moderate Up Moderate Down
  • Dear shiryu008, ...

    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

    By ExcelIsFun [Affiliate User] 1219774490 Reply Spam Moderate Up Moderate Down
  • dealing with macros ...

    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.

    By shiryu008 [Affiliate User] 1219762127 Reply Spam Moderate Up Moderate Down
  • Dear DrSobell, ...

    Dear DrSobell,

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

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1219217010 Reply Spam Moderate Up Moderate Down
  • Couldn't figure it ...

    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! :)

    By DrSobell [Affiliate User] 1219210358 Reply Spam Moderate Up Moderate Down
  • Dear DrSobell, I ...

    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

    By ExcelIsFun [Affiliate User] 1218796416 Reply Spam Moderate Up Moderate Down
  • Hi having a problem ...

    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?

    By DrSobell [Affiliate User] 1218791089 Reply Spam Moderate Up Moderate Down
  • Dear periwink, I ...

    Dear periwink,

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

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1217023635 Reply Spam Moderate Up Moderate Down
  • 5 stars :).

    5 stars :).

    By periwink [Affiliate User] 1217008247 Reply Spam Moderate Up Moderate Down
9 Comments | Add Comment