Share via

EXCEL Copying multiple buttons at the same time

Anonymous
2021-12-31T14:48:00+00:00

Hello,

I have setup many buttons (with assigned macros) and I would like to copy and paste them all at once to another section of the same sheet.

Is there a way to highlight the group for copy/paste? (one of many examples below)

Thanks, Ed

Microsoft 365 and Office | Excel | For business | 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
Answer accepted by question author
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2021-12-31T14:54:38+00:00

    On the Home tab of the ribbon, select Find & Select > Select Objects.

    You can now select multiple "buttons" by dragging a rectangle around them.

    Use Ctrl+C and Ctrl+V to paste them.

    Do not forget to turn off Select Objects when you're done!

    2 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest