Sharing Macros

Don't stop with the learning!

So... if you open the VBE using Alt F11 (better yet, add the Developer tab to your ribbon using Customize Ribbon feature), you can get into VBA easily. Every Excel workbook has a VBA project. So if you have your macros in standard code modules in your own Personal macro workbook, you can open any other workbook and click-drag the modules to the other workbook's VBA project. Thereafter you can have those users either add command buttons to the worksheet, right-click and assign macro... or else they can also add the Developer tab to their ribbons, then on that tab there is a Macros button.. which when they click will show all macros that are available to them. Just as long as "Option Private Module" does not appear at the top of the module, they should be able to see your macros and run them. Be aware of course that some macros which you might record using the Macro recorded will be VERY verbose, and do a lot of cell selection. A good idea is to google the kind of thing you were trying to do, and see how others actually code. The macro recorder is a good place to start for things like filtering, Tables, etc to get a flavor of the syntax... but never let your macros hang onto everything that the macro recorder records, it is 90% extra fluff, especially for example if you were to adjust print setup properties... whew, what a spew of details Excel puts out there!