How to have a macro on other workbooks

[daskalo]

Hey guys, i know this is probably very simple, but I cant figure it out. Is there any way to create like a library of macros so every time i open excel the macros will be there without mattering on what sheet or workbook I am on?

Thanks

Edit: I use MS Excel 2007

 

[Domski]

It's Alt+F11 to open the VBA editor.

Dom

 

[Vinci]

Sorry that should be Alt+f11

 

[daskalo]

So no one answered my question earlier. What are macro libraries what can we use those for?

 

[Domski]

Wasn't it you who asked how to create a library of macros? How would you define one in the context you meant?

I personally use a number of methods of storing code. Personal.xls, add-ins, word documents, sample workbooks all with examples of different code in them either that I can use all the time or refer to as required. They are all library's of code in one way or another I guess.

Dom

 

[daskalo]

Domski,

Yes I did. You guys told me exactly what I need, but i was reading that excel has an option to create a Macro Library and you can use the macros on any sheet that you open without opening other sheets with the macros etc..

 

[kpark91]

Hmm... Interesting. I've never heard about a macro library like that
I think it'd be impossible without manually recording the macros or else there would be no use of personal.xls.

 

[daskalo]

Yeah I also searched google and cant find anything on it lol. He probably does not know what he is talking about.

 

[Domski]

Places like this are as good as you get to a code library to be honest hence why my own collection of code has never made it into a very organised state

Dom

 

[kpark91]

LOL. Probably.
You can probably just add macros into your personal.xls and rename it into a library like categories
or place binary workbooks/macro-enabled workbooks into C:\Users\YourName\AppData\Roaming\Microsoft\Excel\XLSTART

and all the files in the directory will automatically start with excel.

 

[will1128]

I have Module one which has several functions and subs in it. I have several other modules which are functions. I've tried importing all of it to the Personal.xls file to be available across all macros, but I only get ColstoNum available (I've followed directions from here

http://office.microsoft.com/en-us/e...l-macros-from-a-central-file-HA001087296.aspx

Module 1 looks like

Public Sub ColstoNum() ...some VBA
Public Sub Delete() ... some VBA
Public Function Add() ...some VBA

Module 2 through n have a function...

How come when I try to open another Excel file I'm only able to have ColstoNum available from the Personal.xls file even though I've imported the other modules?

Any help would be sincerely appreciated.