Share via

Copy a Macro

Anonymous
2015-08-06T20:41:40+00:00

Guys, using the MS Access Macro GUI, I have a long macro tired to a command button that I need to copy.  What I want to do is create a standalone macro that's not tied to a command button that I can call from any form.  How can I copy the existing macro?

For added clarity, I'm NOT looking to copy the command button that's tied to the Macro. That I can do, but for the LIFE OF ME cannot see how I can copy the Macro logic into a standalone named macro. 

Thank you!

Ken

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-08-06T23:58:51+00:00

    Open source macro collapse all, then Ctrl plus mouse click to select commands, then press Ctrl ＋C ,

    then create new macro and Ctrl V.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-08-06T21:56:11+00:00

    I thought I tried that months ago without luck, but maybe not. Thanks for the suggestion, I'll give it a try.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-08-06T21:19:54+00:00

    You refer to a embed macro which you want to copy to standalone macro

    ？

    How about select all commands press control C to copy, then turn to new macro Ctrl V to paste.

    Another option, transfer macro to VBA,codes.

    Was this answer helpful?

    0 comments