Can I save a macro to a specific workbook?

[Lloydmp]

Hi there,

For clarification what I am looking to do is to try and save the macro to the work book so others who use it don't have to import the macro.
I managed to add an auto lookup macro to the ThisWorkBook in VBA but that applies the macro when you open the workbook.
I want a button or alternative to save & email the Workbook. I already have a functioning code but no idea at all if i can apply it the ThisWorkBook

Thanks in advance!

 

[MARK858]

If you are running a macro off a button then the macro should be in a regular module not the ThisWorkbook module.

 

[Lloydmp]

Doesn't have to be a button, just some what to apply macro after you have edited Workbook.
Is this at all possible?

 

[MARK858]

I don't understand what you are asking...
You write you macro in a regular module (in the VB editor click Insert then module), put a forms commandbutton on the worksheet, an assign macro dialog box appears (if it doesn't right click the button and click assign macro), you select your macro and click ok, save as a macro enabled file type i.e. xlsm, xlsb etc.

 

[Lloydmp]

"For clarification what I am looking to do is to try and save the macro to the work book so others who use it don't have to import the macro."

Like i said above, the people I'm trying to help are not computer literate and I'm trying to save the macro to the workbook so no matter what PC the wok book is opened from the macro doesn't need to be imported its simply with the work book.

Is this possible for a macro that needs to be activated when i choose instead of when the workbook is opened?

 

[MARK858]

They don't import the macro whether it is in the ThisWorkbook or a regular module as you long as you have saved it as a macro enabled file type.

Why do you think they would need to import the macro?

 

[Lloydmp]

So as long as i create/edit/save a work book and ensure its macro enabled the macros will be available for another user on another PC?

Honestly didn't know it worked like this!

 

[MARK858]

So as long as i create/edit/save a work book and ensure its macro enabled the macros will be available for another user on another PC?

Honestly didn't know it worked like this!

Yes but it is the file type that is macro enabled, if it is an xlsx file type then it can't hold a macro (just make sure you are putting the macro in the workbook you are sending and not in your personal workbook).

 

[Lloydmp]

I have been creating all my macros in personal workbook. This has changed so much of what iv been doing. thank you very very much for this!