How to create Macros That are easily accessible for use?

[swade730]

Hello,

My question is regarding the saving , use and transfer of Macros.

I'm new to VBA and my problem of understanding the storage of Macros has been preventing me from excelling in VBA. (Get it!!! EXCEL ing hahaha)/Sorry...bad joke.



I've created a macro that automatically inserts a table into data that is exported into Excel. -In fact a previous member has assisted with coding that for me; I will attach it to this post.
(I'm still confused on the aspect of the code that alters the range of the data...but I'll muscle through that on my own and try to figure it out.)

So the Macro he wrote (Or should I be saying module???) is Set only for this data? I want it to apply to any data set I enter in excel but find I would always have to click on macros, module, blah blah blah.

Like if I want to send someone this code...do they have to save it in a work book or something; so when they put data into excel, they can just push a button to insert the table?
keep in mind the data might have the same amount of rows(which was the topic of my previous post)

If they have several excel files open and want to apply my macro to a specific data set will it automatically add the cool buttons to their specific sheet and stuff?

What I want to accomplish is to have the code enabled on a blank spread sheet with the create table buttons there. And when some one exports the data to excel, its essentially being imported into a blank spread sheet with the buttons to the right which will allow the user to convert the data into a table and back.



Please Let me know if there is further clarification needed. Thank you so much in advance for helping me with my post.