Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-02-2013, 05:59 PM
cyberpaper cyberpaper is offline Word 2003 - Macro to color a row in table? Windows XP Word 2003 - Macro to color a row in table? Office 2003
Novice
Word 2003 - Macro to color a row in table?
 
Join Date: Oct 2010
Posts: 19
cyberpaper is on a distinguished road
Default Word 2003 - Macro to color a row in table?

I'm trying to set up a 2003 Word macro that'll fill a row (or a cell) in a table with color (regardless of whether or not there's any text in the cell\row).

The following method works except that the row's color is overlaid with the black of the selection and I have to click elsewhere to unselect the row.

Here's how I've been doing it:
Cursor in an empty row of a table
Tools > Macro > Record a new macro
Name it, assign a shortcut, OK and recording gadget appears.

Then I go Table > Select > Row (which selects the row in black)


Then Format > Borders and Shading > Color (eg, Blue) > OK
Stop recording.

When I test the macro, it works, but a split second after the row fills with color, the black selection overlays the color. The black selection only goes away after I click somewhere else. The color remains.

This isn't a huge BFD but it's annoying. Anyone able to tell me where I'm going wrong? BTW, the OS is Windows 7. Oddly, I don't recall having the same problem when recorded the same macro in Word 2003 in my old XP system.

Thanks for reading this :-)
Reply With Quote
  #2  
Old 01-03-2013, 01:16 PM
Ulodesk Ulodesk is offline Word 2003 - Macro to color a row in table? Windows 7 64bit Word 2003 - Macro to color a row in table? Office 2010 64bit
Word 2013 Expert Cert
 
Join Date: Sep 2009
Location: Virginia
Posts: 866
Ulodesk is on a distinguished road
Default

Hi, Cycberpaper. The black overlay (perhaps you mean gray?) simply shows that you still have the row selected. The way to remove it is to re-record your macro, including the keystroke(s) you would like to make after filling the cell, such as pressing the down arrow, before ending recording.

Best,
Ulodesk
Reply With Quote
  #3  
Old 01-03-2013, 02:07 PM
cyberpaper cyberpaper is offline Word 2003 - Macro to color a row in table? Windows XP Word 2003 - Macro to color a row in table? Office 2003
Novice
Word 2003 - Macro to color a row in table?
 
Join Date: Oct 2010
Posts: 19
cyberpaper is on a distinguished road
Default

Thanks Ulodesk. I'd figured I needed to dump the selection but couldn't see how to do it. As a final step, I tried right-clicking the selected row to see if there was some sort of de-select available, but the recorder wouldn't allow the move.

Down arrow, eh? Love it :-)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2003 - Macro to color a row in table? Macro to add row to table in a Word form shabbaranks Word VBA 21 11-22-2019 02:44 AM
Word macro doesn't change font color Spideriffic Word VBA 8 11-04-2015 03:47 AM
Word 2010 Page Color not working in macro Sorceress Word 3 10-15-2012 06:02 AM
Word 2003 - Macro to color a row in table? Macro help sought for Word table xan Word VBA 1 04-20-2012 07:50 PM
[Word 2003] Macro's and a UserForm xanuex Word VBA 0 10-19-2009 05:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:54 AM.


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