Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Select color palette using vba Select color palette using vba
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 10-08-2015, 03:20 AM
Catty Catty is offline Select color palette using vba Windows 7 32bit Select color palette using vba Office 2010 32bit
Advanced Beginner
Select color palette using vba 		 
Join Date: Nov 2013
Posts: 39
Catty is on a distinguished road
Default Select color palette using vba
Hi



Is there a way I can automatically select custom colors using a macro/vba? I have tried recording the macro but I get nothing.
Reply With Quote
  #2  
Old 10-08-2015, 03:49 AM
gmayor's Avatar
gmayor gmayor is offline Select color palette using vba Windows 7 64bit Select color palette using vba Office 2010 32bit
Expert
  
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
Select from where to do what with them?
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 10-08-2015, 05:30 AM
Catty Catty is offline Select color palette using vba Windows 7 32bit Select color palette using vba Office 2010 32bit
Advanced Beginner
Select color palette using vba 		 
Join Date: Nov 2013
Posts: 39
Catty is on a distinguished road
Default
Select from the Design Tab (using office 2013) and make the custom color scheme the default for the document.
Reply With Quote
  #4  
Old 10-08-2015, 09:32 PM
gmayor's Avatar
gmayor gmayor is offline Select color palette using vba Windows 7 64bit Select color palette using vba Office 2010 32bit
Expert
  
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
The colour scheme dropdown does not appear to be exposed to VBA. Frankly if you need a specific colour in your template project, it would be better to setup the styles you require including colour in that template and ignore the schemes. The simple desktop application ColorCop is brilliant for matching colours.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to select a custom color palette Catty Word VBA 0 05-06-2015 05:12 AM
Select color palette using vba Character Palette is where? DrHemlock Word 4 05-04-2012 06:06 PM
Office (PowerPoint & Excel) 2003 color palette available in 2010 version? anofficedummy PowerPoint 1 01-27-2012 11:41 AM
Select Series Color - Macro judicial85 Excel Programming 0 03-14-2011 02:35 PM
Select color palette using vba Select text by color Invain Word 1 02-14-2010 07:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:11 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft