Macro renaming
in [Word VBA]
|
From: G Teachman on 28 Jan 2010 15:00 When creating a macro I don't always give it a descriptive name. I would like to know how to rename the macro. THanks, -- G Teachman Soil Scientist
From: Jay Freedman on 28 Jan 2010 15:57 Press Alt+F8 to open the Macros dialog. Select the macro you want, and click the Edit button to open the macro editor. The first line of the macro contains its name, between the keyword "Sub" and a pair of parentheses. Change the name there, and then click the Save button. For example, to rename Macro1 as MyFirstMacro, change the line Sub Macro1() to Sub MyFirstMacro() -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. G Teachman wrote: > When creating a macro I don't always give it a descriptive name. I > would like to know how to rename the macro. > > THanks,
From: Fumei2 via OfficeKB.com on 28 Jan 2010 16:26 Just be aware that if you had assigned a keyboard shortcut to a procedure (macro) - say Alt-6 for Macro1 - that shortcut will NOT be carried over to the renamed procedure. You would have to manually reassign the shortcut key. Jay Freedman wrote: >Press Alt+F8 to open the Macros dialog. Select the macro you want, and click >the Edit button to open the macro editor. The first line of the macro >contains its name, between the keyword "Sub" and a pair of parentheses. >Change the name there, and then click the Save button. > >For example, to rename Macro1 as MyFirstMacro, change the line > >Sub Macro1() > >to > >Sub MyFirstMacro() > >> When creating a macro I don't always give it a descriptive name. I >> would like to know how to rename the macro. >> >> THanks, -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/word-programming/201001/1
|
Pages: 1 Prev: When recording a macro a dialog box doesn't display Next: Word 2007 vs Word 2003 VBA autotext |