[FIXED] FYI: Bug in PowerPoint for Mac version 16.79.1 breaks setting colors in VBA
Thu Nov 23, 2023 2:07 am
---
This bug appears to be fixed in PowerPoint for Mac version 16.79.2.
---
The latest version of PowerPoint for Mac as of this writing (16.79.1), run on an Intel Mac (or an Apple Silicon Mac using Rosetta), sets the incorrect value when changing colors in VBA.
Say for example you want to change the color of the shape to white, like so:
When running the macro, affected versions of PowerPoint for Mac sets the blue value (the third number) incorrectly. Instead of the shape turning white, you get yellow, or RGB(255, 255, 138) instead.
At best, your project will not appear as intended. At worst, your project will break if your project depends on shapes being specific colors for conditional checks.
If someone reports an issue with your project caused by this PowerPoint bug, you have two options to resolve their problem.
NOTE: DO NOT DO THIS IF POWERPOINT WAS INSTALLED THROUGH THE MAC APP STORE! The Mac App Store version uses a different update distribution channel. Users who installed PowerPoint through the Mac App Store unfortunately cannot downgrade and will need to wait for Microsoft to release a patch.
Update your project to reference colors in long format.
For example, rewrite the above code snippet as follows:
The long data type number 16777215 is another way to express RGB(255, 255, 255). Running this macro on affected versions of PowerPoint for Mac will indeed change the shape's color to white.
To convert your RGB colors to long format:
Create a temporary macro that contains the RGB color in a message box, like so:
Run the macro, note the number on the message box, and replace all references of the RGB color with that number.
Hopefully this helps you in case anyone reaches out to you about your project acting strange! It was a nightmare trying to reproduce the bug reports I received with my project because I didn't realize the same version of PowerPoint can act differently on Intel and Apple Silicon Macs...
I will follow up this post if or when Microsoft fixes this bug with PowerPoint for Mac.
This bug appears to be fixed in PowerPoint for Mac version 16.79.2.
---
The latest version of PowerPoint for Mac as of this writing (16.79.1), run on an Intel Mac (or an Apple Silicon Mac using Rosetta), sets the incorrect value when changing colors in VBA.
Say for example you want to change the color of the shape to white, like so:
- Code:
ActivePresentation.Slides(1).Shapes("rectangle").Fill.ForeColor.RGB = RGB(255, 255, 255)
When running the macro, affected versions of PowerPoint for Mac sets the blue value (the third number) incorrectly. Instead of the shape turning white, you get yellow, or RGB(255, 255, 138) instead.
At best, your project will not appear as intended. At worst, your project will break if your project depends on shapes being specific colors for conditional checks.
Workarounds
If someone reports an issue with your project caused by this PowerPoint bug, you have two options to resolve their problem.
- Instruct the user to downgrade PowerPoint for Mac to version 16.78.3. Downgrade instructions:
- Uninstall PowerPoint by dragging the PowerPoint application to the trash.
- Go to this Microsoft page and download the PowerPoint package for 16.78.3.
- Run the installer.
- Once installed, make sure "Automatically keep Microsoft apps up to date" is unchecked in Microsoft AutoUpdate.
NOTE: DO NOT DO THIS IF POWERPOINT WAS INSTALLED THROUGH THE MAC APP STORE! The Mac App Store version uses a different update distribution channel. Users who installed PowerPoint through the Mac App Store unfortunately cannot downgrade and will need to wait for Microsoft to release a patch.
For example, rewrite the above code snippet as follows:
- Code:
ActivePresentation.Slides(1).Shapes("rectangle").Fill.ForeColor.RGB = 16777215
The long data type number 16777215 is another way to express RGB(255, 255, 255). Running this macro on affected versions of PowerPoint for Mac will indeed change the shape's color to white.
To convert your RGB colors to long format:
- Code:
Sub rgb_to_long()
 MsgBox RGB(255, 255, 255) ' Replace the numbers with your RGB values!
End Sub
Hopefully this helps you in case anyone reaches out to you about your project acting strange! It was a nightmare trying to reproduce the bug reports I received with my project because I didn't realize the same version of PowerPoint can act differently on Intel and Apple Silicon Macs...
I will follow up this post if or when Microsoft fixes this bug with PowerPoint for Mac.
rusnakcreative likes this post
Re: [FIXED] FYI: Bug in PowerPoint for Mac version 16.79.1 breaks setting colors in VBA
Sun Nov 26, 2023 3:11 pm
Excellent workaround, Tim!
GamesByTim likes this post
Re: [FIXED] FYI: Bug in PowerPoint for Mac version 16.79.1 breaks setting colors in VBA
Wed Nov 29, 2023 9:01 pm
This bug appears to be fixed in PowerPoint for Mac version 16.79.2.
rusnakcreative likes this post
Re: [FIXED] FYI: Bug in PowerPoint for Mac version 16.79.1 breaks setting colors in VBA
Fri Dec 08, 2023 1:41 am
It has come to my attention that the Mac App Store version of PowerPoint has NOT been updated to version 16.79.2...
It is possible Microsoft will skip over to the next version (16.80) for the Mac App Store. Microsoft historically releases Office updates the 2nd Tuesday of the month, so there should be an update available by December 12, 2023.
Very frustrating, Microsoft!
It is possible Microsoft will skip over to the next version (16.80) for the Mac App Store. Microsoft historically releases Office updates the 2nd Tuesday of the month, so there should be an update available by December 12, 2023.
Very frustrating, Microsoft!
Re: [FIXED] FYI: Bug in PowerPoint for Mac version 16.79.1 breaks setting colors in VBA
Tue Dec 12, 2023 8:07 pm
PowerPoint for Mac version 16.80 released today on both Microsoft's website and the Mac App Store. The bug remains fixed in this version.
rusnakcreative and JadeJohnsonIndustries™ like this post
- Sponsored content
- Flashcards for PowerPoint
- Wheel of Fortune for PowerPoint - Games by Tim - Game
- So I finally fixed it...
- How To Port Any Of Your Existing PowerPoint Games To The JadeJohnson Games Custom Switch Emulator Developer Kit For PowerPoint 2010+
- VOILA! One Click PowerPoint Quiz Maker (AKA: Yontaku PowerPoint Quiz Maker): Free Download
Permissions in this forum:
You cannot reply to topics in this forum
|
|