I have a button on a form I now wish to turn into a macro and call from other forms. I have tried to copy the code I entered into the button but it does not copy to the macro. Short of rewriting the whole thing are there any tricks to copy button embedded macros to standalone macros?

---

Reply from Alex Hedley:

You can copy the button and it will copy the macro with it.

MS Blog
Forms(0).Controls("foo").OnLoadMacro = Forms(1).Controls("bar").OnOpenMacro
DoCmd.SaveText acMacro, "foo", "Macro1"
.*Macro "shadow properties"

Alternative

Database Tools
Convert Form's Macros to Visual Basic