Oh, and to respond to Neil, you CAN add keyboard shortcuts to your macros. Kath Bowman Technical Writer Direct +61 8 8343 3865 kath.bowman@xxxxxxxxxxxxxxxx<mailto:kath.bowman@xxxxxxxxxxxxxxxx> Saab Australia Pty Ltd 21 Third Avenue Mawson Lakes SA 5095 www.saabgroup.com/au<http://www.saabsystems.com.au/> [cid:image001.jpg@01D00FAA.84045DC0] This e-mail is private and confidential between the sender and the addressee. In the event of misdirection, the recipient is prohibited from using, copying or disseminating it or any information in it. Please notify the above of any misdirection. From: austechwriter-bounce@xxxxxxxxxxxxx [mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of Neil Maloney Sent: Thursday, 4 December 2014 10:06 AM To: austechwriter@xxxxxxxxxxxxx Subject: atw: Re: Word macro help Thanks for that rather startling news, Nick. Not that I want to move away from Word 2003 anyway, but not being able to assign keyboard shortcuts to macros would kill my productivity for the bread-and-butter formatting work I do. It would be an overriding reason for me to never upgrade, no matter what, until that functionality was restored. Just to check whether it has been removed or not, however, the following procedure is the same as shown in Rhonda's Cybertext Newsletter, except that it mentions, for macros, to choose "Macros" in the Categories list: http://wordribbon.tips.net/T007120_Defining_a_Shortcut_for_a_Macro.html So, is there a "Macros" item in the Categories list, and does it indeed allow keyboard shortcuts to be assigned to macros? Very interested to hear if it is there or not, although, as mentioned, I'm happy to keep 2003 going until e.g. it's no longer possible to convert 2003 documents to and from and the latest Word version. (I've read posts on this list where there are problems in conversions to and from 2003, but I've not had any in the work I do.) Neil. Reduce your carbon footprint, fuel your debates with testosterone. (To quote Macquarie University’s John McAneney and others: “Studies to-date of long-term insurance or economic disaster loss histories caused by extreme weather — tropical cyclones, floods, bushfires and storms — have been unable to identify a contribution from human induced climate change.” To quote Harvard University: "Moving our endowment beyond fossil fuels and reinvesting in our future.") On 4/12/2014 10:05 AM, Nick Shears wrote: Sadly, it seems that KB shortcut customization was removed in Word 2010 and remains removed in 2013. L Nick Shears From: austechwriter-bounce@xxxxxxxxxxxxx<mailto:austechwriter-bounce@xxxxxxxxxxxxx> [mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of Rhonda Bracey Sent: Wednesday, 3 December 2014 5:47 PM To: austechwriter@xxxxxxxxxxxxx<mailto:austechwriter@xxxxxxxxxxxxx> Subject: atw: Re: Word macro help You can assign a KB shortcut to any macro or hidden (or not so hidden) Word task. See these instructions: https://cybertext.wordpress.com/2010/08/30/word-assign-a-keyboard-shortcut-to-a-task/ Instructions are for Word 2003 and 2007; might be slightly different for earlier or later versions, but not a lot different. Rhonda Rhonda.bracey@xxxxxxxxxxxxxxxx<mailto:Rhonda.bracey@xxxxxxxxxxxxxxxx> Website: http://cybertext.com.au Blog: http://cybertext.wordpress.com From: austechwriter-bounce@xxxxxxxxxxxxx<mailto:austechwriter-bounce@xxxxxxxxxxxxx> [mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of Geoffrey Sent: Wednesday, 3 December 2014 2:25 PM To: austechwriter@xxxxxxxxxxxxx<mailto:austechwriter@xxxxxxxxxxxxx> Subject: atw: Re: Word macro help Thanks Suzy. That works. But I wish I had a keyboard shortcut. I’m a cat when it comes to mice. Geoffrey Marnell Principal Consultant Abelard Consulting Pty Ltd P: 03 9596 3456 M: 0419 574 668 F: 03 9596 3625 Web: www.abelard.com.au<http://www.abelard.com.au/> From: austechwriter-bounce@xxxxxxxxxxxxx<mailto:austechwriter-bounce@xxxxxxxxxxxxx> [mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of Suzy Davis Sent: Wednesday, 3 December 2014 5:06 PM To: austechwriter@xxxxxxxxxxxxx<mailto:austechwriter@xxxxxxxxxxxxx> Subject: atw: Re: Word macro help Hi Geoffrey Not wanting to do Howard out of paid work, but copy this macro to your Normal template Try this… Macros: Click on the Developer tab (if you can’t see it, you can make it visible via File > Options) Click on Record macro, give it a name, and click Keyboard to assign keystroke Click OK Stop it. Doesn’t matter what you do. This will create it in the Visual Basic area. Press Alt+F11 will open the VB area Under Normal you will see Modules>New Macros Double-click this, and you will see that it has created a Sub [your macro name] – the one you just recorded. In between the Sub and End Sub Paste this. Dim myString as String myString = Selection.Range Selection.Range = “\(“ & myString & “\)” Let’s say your macro is called “Test” Now go into File > Options (assuming you are using Word 2010 or 2013) Select Quick Access Toolbar Select Macros in the Choose Commands from box Select your macro in the list This will add it to the QAT. I don’t work with keyboard shortcuts, so hopefully someone can Kind regards Suzy Suzy Davis Microsoft Word Templates, Apps for Microsoft Office & Documentation Projects [cid:image002.png@01D00FAA.84045DC0]<http://www.appsforoffice.com/> [cid:image003.png@01D00FAA.84045DC0]<http://au.linkedin.com/pub/suzy-davis/6/5ba/4b1>[cid:image004.png@01D00FAA.84045DC0]<http://www.facebook.com/pages/Apps-for-Office/136256423063414> [cid:image005.png@01D00FAA.84045DC0] <http://twitter.com/#%21/AppsForOffice> www.appsforoffice<http://www.appsforoffice.com/>.com If you spend 80% of your document time on formatting, instead of writing and perfecting The APPS FOR OFFICE system has been designed for you: apps FREE - quick easy formatting shortcuts (it’s free) apps WorkSmart - try for 30 days (includes report & proposal templates) www.appsforoffice.com/wp-html/products.html<http://www.appsforoffice.com/wp-html/products.html> Support: support@xxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxx> Forum: http://appsforoffice.freshdesk.com/support/discussions PO Box 404 Brighton VIC 3186 (Melbourne) Australia Direct +61 3 9593 6568 Mobile +61 433 489 989 Email suzy.davis@xxxxxxxxxxxxxxxxx<mailto:suzy.davis@xxxxxxxxxxxxxxxxx> From: austechwriter-bounce@xxxxxxxxxxxxx<mailto:austechwriter-bounce@xxxxxxxxxxxxx> [mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of Geoffrey Sent: Wednesday, 3 December 2014 4:44 PM To: austechwriter@xxxxxxxxxxxxx<mailto:austechwriter@xxxxxxxxxxxxx> Subject: atw: Re: Word macro help Hi Howard Is it possible with VBA to wrap selected text in some specified characters? The background is this: I have a lot of mathematics that is partially Latex-compliant, but I need to insert the opening Latex characters (\() and the closing Latex characters {\)). For example, I have 3^x-2 in the manuscript and I want quickly change that to \(3^x-2\). It would be good if I could just select 3^x-2, press a key combination and get \(3^x-2\). Is this do-able? What fee would you charge for designing the macro? Cheers Geoffrey Marnell Principal Consultant Abelard Consulting Pty Ltd P: 03 9596 3456 M: 0419 574 668 F: 03 9596 3625 Web: www.abelard.com.au<http://www.abelard.com.au/> From: austechwriter-bounce@xxxxxxxxxxxxx<mailto:austechwriter-bounce@xxxxxxxxxxxxx> [mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of Howard Silcock Sent: Wednesday, 3 December 2014 10:06 AM To: austechwriter@xxxxxxxxxxxxx<mailto:austechwriter@xxxxxxxxxxxxx> Subject: atw: Re: Word macro help Try replacing .Wrap = wdFindAsk with .Wrap = wdFindStop Howard On 3 December 2014 at 09:23, Geoffrey <geoffrey@xxxxxxxxxxxxxx<mailto:geoffrey@xxxxxxxxxxxxxx>> wrote: Hi austechies I’m stuck with a Word macro. All I want to do is have = replaced by &= in a selection of text. This is the code that the record macro command generates: Sub equals() ' ' equals Macro ' ' With Selection.Find .ClearFormatting .Replacement.ClearFormatting .Text = "=" .Replacement.Text = "&=" .Forward = True .Wrap = wdFindAsk .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .Execute Replace:=wdReplaceAll End With End Sub The problem is that this macro replaces = with &= throughout the entire rest of the document, not just in the text selected. That’s not what I want. Any ideas? Geoffrey Marnell Principal Consultant Abelard Consulting Pty Ltd P: 03 9596 3456 M: 0419 574 668 F: 03 9596 3625 Web: www.abelard.com.au<http://www.abelard.com.au/>