help with personnal workbook reqd

[smiler44]

I have written some macros that may be distributed to other people.
It would be nice to have the macros run from the personal work book.

Is there a way I can put macros and modules into their personal work book automatically by running a macro such as an "install" macro contained within the workbook I send to them? My workbook will then no longer be required.

this is for excel 2010

thanks
smiler44

 

[Trevor G]

There are several options, but take a look at this option about creating an Add In.

http://www.fontstuff.com/vba/vbatut08.htm

 

[smiler44]

Thanks Trevor G I've had a read. My functions will be contained within what ever I distribute.

you said there are there are several options. can you expand on that and tell me how?

Thanks
smiler44

 

[Brianwarnock]

If you Google
Excel macro distribution
You will get lots of hits regarding Add-ins, I was a beginner on Office products when I did this over 15 years ago and the only thing I can remember is that I did it via Add-ins.

Sorry I cannot be more helpful

Brian

 

[Brianwarnock]

https://support.office.microsoft.co...536-8e5e-b6a65d6c1283&ui=en-US&rs=en-GB&ad=GB

The last paragraph of the above might give you an approach if the users do not have any personal code, ie all users have the same macros and UDF .

Brian

 

[Trevor G]

Thanks Trevor G I've had a read. My functions will be contained within what ever I distribute.

you said there are there are several options. can you expand on that and tell me how?

Thanks
smiler44

Taking into account that you have stated it will be contained in the workbook there shouldn't be a concern as the code will work from within the workbook you distribute.

Check out the following link http://www.cpearson.com/excel/vbe.aspx

Chip Pearson will explain and there are some options here.

Brian has also posted a good idea to consider.

 

[smiler44]

thanks gents I will try these suggestions. did not think for one moment it was going to be this difficult

smiler44