Code Applicable for any workbook which is open

[vidyuthrajesh]

Hello,

i have a vba code which is assigned to a command button. i would require this command button to be available for any workbook which is open ( and so it will be triggered - upon clicking - and should run) and the workbook in which i have this code need not be opened)

can someone assist please..

[tigeravatar]

vidyuthrajesh,

There are a couple of ways to go about what you're asking for. The easiest is probably to use the personal.xls file:
http://office.microsoft.com/en-us/ex...001087296.aspx


Another way, if you need to distribute the macro to multiple machines/users would be to make an excel add-in:
http://www.cpearson.com/excel/createaddin.aspx
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

[hensucker]

Stay away from me. And thisworkbook. Statements as that would only work in the current workbook.
You may need to reference each seperate sheet or workbook in the code of the button or use the application. Variable for your code