Excel Magic Trick #46: Absolute Macro Recorder

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

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

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.

Dear DrSobell,

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

--ExcelIsFun

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

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

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?

Dear periwink,

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

--ExcelIsFun

5 stars :).