Yes, Chip, removing formatting altogether is useful and I'm glad Ken pointed out the context key method as I hadn't used that before. One of the big reasons I have an extra issue with font color is that I use the high contrast yellow on black font scheme in Windows. Unfortunately, as versions of Windows have advanced, Windows seems to have lost it's intelligence around automatic font color, which is what I've always defaulted my settings to. Now, If I sent an email in Outlook, it's quite possible that the yellow font in which I view my email will go to the recipient that way. Or, more consistently, trying to print Excel worksheets results in printing a light font, not black, especially if using a color printer. I'd use the plain text message settings for Outlook, but especially at work, I want to use other formatting options and the ability to send live hyperlinks. I now have my font defaulted to black in color, which typically works, but in a professional setting, I li ke to double check it. When I upgraded to Windows 7 and office 2010 at work, I lost most ability to view any font or highlighting color options on my screen while in High contrast mode. I called the Microsoft accessibility line and the rep only showed me a couple mildly helpful things but was unable to resolve the issue. It has its advantages at times, but also has it's disadvantages. For example, when I'm in Excel, it flat out will not show me any of the cell shading colors, which means I could send someone a really funky looking file if I'm not careful. I am grateful for the Insert E command in WE to get sense of what is there, but doing that cell by cell is not fun.
Anyway, that's a long response to say that I cannot fully rely on the automatic font color option and need to select the black font, which is not a color on the first color palate. I have to go to more colors and find this one button that my coworkers helped me find to click on a straight black options. Hence the need for a macro to do this multi step process. Sometimes in Outlook I'll select all the font and choose a dark blue font, just because it's close enough and on the initial color drop down palate. -----Original Message----- From: Talk [mailto:[email protected]] On Behalf Of Chip Orange via Talk Sent: Friday, June 12, 2015 7:14 PM To: 'Marc Solomon'; 'Window-Eyes Discussion List' Subject: RE: best way to accomplish this macro? Hi Marc and Robin, I believe Ken's idea is worth considering, however, it should come with some caviotts: you don't just lose the color of the text when you paste like this; you lose *all* formatting, which includes underlining, bolding, sizing, and even the paragraph characters (they aren't text). It can really leave you with a mess if you had highly formatted text to begin with. Reformatting the text is only possible when you know exactly how it looked before you started. I think it's much easier, if color is all Robin is concerned about, to select the entire document after all pasting is done, and then to click on the font color button in the "home" ribbon tab (I don't know why but Window-Eyes seemed to speak the dialog choices slightly better if you used the button to get to the dialog than if you used the context menu choice). Then, just take the mouse cursor and go to the top of the color dialog and click on the "automatic" choice with the mouse (as I had difficulty getting Window-Eyes to find and speak this choice using the keyboard). That's it! You now have uniformly colored text, and unless you've done something to your default settings, it will be black. I think you have an "ok" button to click on if you came in via the context menu "font" item. If you can do this with HotSpot Marc's right, it's by far the easiest, but I didn't see keyboard shortcuts for the colors, and without those it isn't so easy, and when dialogs are opening and closing, and you need to pause to let a dialog open before doing the next step, well I am not sure how easy it will be. I admit to not being an experienced hotspotter. Robin, let me know if you try this and it seems easy enough and if it works. Hth, Chip -----Original Message----- From: Talk [mailto:[email protected]] On Behalf Of Marc Solomon via Talk Sent: Friday, June 12, 2015 3:38 PM To: Van Lant, Robin; Window-Eyes Discussion List Subject: RE: best way to accomplish this macro? Below is another suggested solution that came from Ken Scott. He isn't subscribed to the list and asked me to post the message on his behalf. Hi Marc, I am hoping that my guess on how to reach you is correct. I am not subscribed to the talks list so I am writing to you to offer an easier method to address a concern of a list member. I hope that you will forward the following information to the talks list. Mr. Van Lant does not need to create a macro. All he has to do when pasting text is press the context menu key down arrow to where Window-Eyes announces keep source formatting. He then arrows right until he reaches the keep text only option and presses enter. This pastes the text into the destination document and applies the destination document's formatting. If he needs specific formatting, he can create a Word document or template with any required formats. This should be a lot easier than trying to create a macro. I am assuming that Mr. Van Lant is using fairly recent versions of Window-Eyes and Microsoft Office. Best Regards, Ken Scott -----Original Message----- From: Talk [mailto:[email protected]] On Behalf Of Van Lant, Robin via Talk Sent: Friday, June 12, 2015 1:36 PM To: Window-Eyes Discussion List Subject: best way to accomplish this macro? I'm thinking I want to create a macro that will enable me to quickly apply a font color change to selected text. Usually what I'm trying to do is to select all the text in an office product (be it Word, Excel or Outlook) and select black font to ensure that my font is a consistent color after cutting and pasting from multiple sources. In office 2010, the font color selection tools are more cumbersome and I don't fully understand them, but I've managed to muddle through to select black. This takes multiple keystrokes and often my mouse, too. Curious as to which is the best tool for creating macros. I'm considering the Office macros, the Read Macro app on App Central, and the HotSpot app. What some of the differences would be. I image the Office macro would be specific to the particular program, whereas both WE apps could be potentially used across platforms (maybe not in my specific situation above). Any other thoughts on the pros and cons to the various means for creating a macro and why I might choose one over another? What other things have you found useful to create with HotSpot and Record Macro? Robin Van Lant | Sr. Program Manager Strategy & Performance Management | Key Equipment Finance 720-304-1060 | [email protected] This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information. 127 Public Square, Cleveland, OH 44114 If you prefer not to receive future e-mail offers for products or services from Key send an e-mail to mailto:[email protected] with 'No Promotional E-mails' in the SUBJECT line. _______________________________________________ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/msolomon%40ais quared.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com _______________________________________________ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/lists3717%40co mcast.net. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com _______________________________________________ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/robin_van_lant%40key.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com _______________________________________________ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/archive%40mail-archive.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com
