Inserting a Macro Button through VBA

[mille91]

At my work we have a series of files that contain peoples names, last names, companies, and emails. To make searching through all these files easier I have created a macro that merges all the workbooks into one master workbook.

I've found the code that merges all the files into one sheet, and I have even made it look appealing by adding borders, colors, font styles, etc. All this works flawlessly

Now, to push it over the edge I want to put in a search function that will filter all the names, I have the code for all of this but have a problem using it. This is where your kind help comes in.


The code that merges all the workbooks together copies them into a different sheet, so I have two options (atleast two that I see): a) figure out a code that allowes me to insert a button into my copied sheet using VBA, or, b) Figure out how to merge my workbooks without copying them to another sheet and just attaching another button to my workbook.

Any help is appreciated. Also, I would show you my code, but I have no idea how to insert it into my thread.

[mille91]

Please Login or Register  to view this content.

Found it. I know that most the code here can probably be more efficient, but I'm not that advanced. The code that merges the workbooks appears first.