Excel - MAC xlautomatic: Episode 1451

Описание: Microsoft Excel Tutorial: Excel for Mac 2011: How to Fix the Macro Recorder Bug with Color Recording | MrExcel Podcast.

Welcome to another episode of the MrExcel Podcast. In this episode, we will be discussing a common issue that has been brought to my attention twice in the past week. It seems that many of you are using Macs and are having trouble with the macro recorder. Well, fear not, because I have a solution for you.

If you are a Mac user, I would love to hear from you. Shoot me an email at [email protected] and let me know if you are watching this video on a Mac. I am curious to see how many of our viewers are using Macs and if it's time for me to start creating more content specifically for Mac users.

Now, let's get into the issue at hand. In Excel for Mac 2011, there is a bug with the macro recorder where it records the color as "xlAutomatic" instead of the actual color code. This can be frustrating, but luckily there is a simple workaround. First, we need to grab the color code for the desired color by going to the Paint bucket, selecting "More Colors," and then writing down the red, green, and blue values. Then, we can use the RGB function in the macro editor to input the correct color code.

It's important to note that this bug is not uncommon, as the VBA macro recorder was not available in Excel 2008 and was only recently reintroduced in Excel 2011. So, the Mac team is still working out some kinks. But, with the use of the RGB function, we can easily work around this issue and continue using the macro recorder on our Macs.

I want to give a special thanks to Joe for bringing this issue to my attention and for all of you for tuning in. If you have any other Excel questions or topics you would like me to cover, please leave a comment below. And don't forget to subscribe to our channel for more helpful Excel tips and tricks. Thanks for watching and I'll see you in the next episode of the MrExcel Podcast.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...


Table of Contents:
(00:00) Introduction and Sponsorship
(00:14) Question about Excel for Mac
(00:24) Request for Mac users to contact MrExcel
(00:36) Bug with macro recorder in Excel 2011
(01:03) Solution using RGB function
(02:26) Demonstration of solution
(03:09) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Excel for Mac 2011
Font color
Interior color
Macro editor
Macro recording bug
More Colors
Red, green, blue
RGB function
VBA macro recorder
xlAutomatic


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...


Mark this date: October 18th, 2011 - Bill "MrExcel" Jelen's first Podcast for MAC Users!

Joe has Excel 2011 for Mac. He turned on the macro recorder and changed some colors in his worksheet. The Excel Mac Macro Recorder uses 'xlAutomatic' for all colors instead of recording the actual color. In this, my first-ever podcast directly focusing on Excel for Mac issues and those using Excel for the Mac, I will show you how to use the 'RGB Function' to fix you macro.

Using Excel on your MAC? Bill wants to know. Drop him a note at * bill @ mrexcel.com * and tell him what version of Excel for Mac you use. As Bill mentioned in today's podcast, "...maybe it's time".

...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!

"The Learn Excel from MrExcel Podcast Series"

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!