View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wayne_Perth_WA Wayne_Perth_WA is offline
external usenet poster
 
Posts: 3
Default 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