Please wait while the video loads.
You will need Adobe's Flash Player plugin to view this page properly.
International
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.
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! :)
By DrSobell [Affiliate User] 1219210358 Reply Spam [+0] Moderate Up Moderate Down RemoveDear 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?
By DrSobell [Affiliate User] 1218791089 Reply Spam [+0] Moderate Up Moderate Down RemoveDear periwink,
I hope when you show off your new tricks to your boss, he gives you 7 stars!!
--ExcelIsFun
5 stars :).
By periwink [Affiliate User] 1217008247 Reply Spam [+0] Moderate Up Moderate Down RemoveRated 0.0 0 Views
Rated 0.0 0 Views
Rated 0.0 0 Views
MrExcel's Learn E...xcel #954 - Macro Display Dialog 1 min ago
Rated 0.0 0 Views
Sayonara Davey Fu...nny People in Theaters 7.31 1 min ago
Rated 0.0 0 Views
Advanced Excel: C...reating a Simple Macro 1 min ago
Rated 0.0 0 Views
04:28
Advanced Excel: A...ttaching a Macro to a Button 1 min ago
Rated 0.0 0 Views
01:23
Example Macro Vba...In Excel - Automatic Report. 1 min ago
Rated 0.0 0 Views
07:15
Excel 2007 Course...: Lesson 3-12 Understand Absolute and Relative Cell References 1 min ago
Rated 0.0 0 Views
03:53
Macros Vba Excel...MRP (Material Requeriment Plan.) 1 min ago
Rated 0.0 0 Views
02:21
Excel Gantt Macro..., Project Managament With Gantt Chart. 1 min ago
Rated 0.0 0 Views
03:06
An Interesting Ma...cro in Excel 1 min ago
Rated 0.0 0 Views
01:51
Microsoft Excel M...acros 1 min ago
Rated 0.0 0 Views
04:57
Recording Macros...- Excel 2003 1 min ago
Rated 0.0 0 Views
02:46
MrExcel's Learn E...xcel #957 - 954 Redux 1 min ago
Rated 0.0 0 Views
Rated 0.0 0 Views
Rated 0.0 0 Views
Rated 0.0 0 Views
Excel Magic Trick...#149: Reverse 2-Way Lookup No Duplicates 1 min ago
Rated 0.0 0 Views
World Easy Magic...Trick 1 min ago
Rated 0.0 0 Views
Coin Vanish Magic...Trick Tutorial 1 min ago
Rated 0.0 0 Views
01:21
American Got Tale...nt - Man Cut in 2 Pieces Magic Trick 1 min ago
Rated 0.0 0 Views
00:54
Crazy Man's Handc...uffs Magic Trick Revealed 1 min ago
Rated 0.0 0 Views
04:28
Magic Trick Dress...Change 1 min ago
Rated 0.0 0 Views
04:49
Excel Magic Trick...s # 1: Formulas & Cell References 1 min ago
Rated 0.0 0 Views
09:46
Excel Magic Trick...#90: Consolidation 1 min ago
Rated 0.0 0 Views
00:56
Street Fair Chop...Cup Magic Trick by Todd Duff 1 min ago
Rated 0.0 0 Views
02:05
IMPOSSIBLE Magic...Trick 1 min ago
Rated 0.0 0 Views
02:39
Amazing Magic Tri...ck with Change of Clothes 1 min ago
Rated 0.0 0 Views
00:55
! !Amazing Magic...! ! Think Again 1 min ago
Rated 0.0 0 Views