Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

How to copy a button to multiple worksheets

0

I work for an institution with 72 divisions.  I create a document broken down with each division having its on worksheet.  I have an index on the first page to go directly to the sheet they want.  But some of our employees can't get back to the index easily.  So I created a button to take them there. 

How do I copy the button to each page without having to open each worksheet.  Usually I copy somehting and hold the shift key, select all, then paste where I want it for all sheets, but with the copy/paste of the button excel says it can't paste the data.  Any help is apprecitated.

Thanks,

Answer
Discuss

Answers

0
Selected Answer

Hello clcwalker 

This can be easily achieved using VBA - copy the code from the attached file "Copy Button Macro". All you need to do is select your 'button' before running the macro. Hope this works for you.

If you want your index to always be current have a look at "Create WorkBook TOC" file (instructions in workbook)

Enjoy, Doug

Discuss

Discussion

Thank you so much, this worked great!  I apprecite the help.
clcwalker (rep: 4) Jul 3, '20 at 12:48 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login