Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 03-29-2020, 08:22 PM
Charles Kenyon Charles Kenyon is offline Shading/Borders in a Table: A Way to Memorize/Preset? Windows 10 Shading/Borders in a Table: A Way to Memorize/Preset? Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,474
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Try it here: Table Cell Color Keyboard Shortcuts
I updated it to include shortcuts for the rows.


The keyboard shortcut Ctrl+2,B means press Ctrl+2 followed by the letter "B." This lets you use two keys for 20 macros.

You can also just run the macros.

I rechecked the shortcuts before posting.


[EDIT: Yes, it is certainly possible to edit the Add-In to add your own colors, or to change the keyboard shortcuts. The vba is not locked. For custom colors, I recorded a macro changing the color and then used that color in the vba code. Note that the macros are set to not give an error message if the selection is not in a table. Note also, that if you run it in the wrong cell, Ctrl+Z will undo.]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Column shading flowing outside of table basils57 Word Tables 5 07-09-2018 06:03 AM
Table Not Shading Correctly busybeas Word Tables 1 02-01-2017 09:14 AM
Tweaking preset pivot table styles New Daddy Excel 1 12-12-2013 05:20 PM
Shading/Borders in a Table: A Way to Memorize/Preset? Moving cell content without moving borders & shading? unittwentyfive Excel 1 10-25-2013 12:56 PM
Shading/Borders in a Table: A Way to Memorize/Preset? Page-crossing borders in a table with hidden between-cell borders tenpaiman Word 2 08-08-2012 07:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:26 AM.


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