Load VB Code every time Excel opens
 

I have a chunck of VB code that I want to be loaded every time MS Excel 2003
is loaded and it can be run from a custom button from a menu bar.

How can I achieve this?

At present I have to open a csv file that has been created from another
application and then run this code from a module within a saved excel sheet.
Although this works it opens a excel sheet every time and can become messy.

Thanks in advance

Wayne

Load VB Code every time Excel opens
 

Wayne,

The easiest way is to put your code in an add-in and select the add-in under
Tools, Add-ins. It will always load. Within the add-in you can create a
toolbar button and menu entry that will also load to give you access to your
routine.

Robin Hammond
www.enhanceddatasystems.com

"Wayne_Perth_WA" wrote in message
...
I have a chunck of VB code that I want to be loaded every time MS Excel
2003
is loaded and it can be run from a custom button from a menu bar.

How can I achieve this?

At present I have to open a csv file that has been created from another
application and then run this code from a module within a saved excel
sheet.
Although this works it opens a excel sheet every time and can become
messy.

Thanks in advance

Wayne

Load VB Code every time Excel opens
 

Hi Wayne,

Check the following link to a previous post of mine; it may be what
you're looking for:
http://www.excelforum.com/showthread...480#post968480

Hope this helps,
theDude


--
theDude
------------------------------------------------------------------------
theDude's Profile: http://www.excelforum.com/member.php...o&userid=16550
View this thread: http://www.excelforum.com/showthread...hreadid=375848