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

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

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