View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Loo John Loo is offline
external usenet poster
 
Posts: 4
Default How Do I Run Subroutines in .xla files from VBA Code in Spreadshee

I created an add-in (.xla extension) from a spreadsheet with quite a bit of
code. I have installed the add-in, and can see it from the Tools- Add-ins
dialog box. It also appears in the VBE Project Map.

However, I can not access the code except by associating it with a button or
command menu. When I try to access it in code, I get a "Subroutine not
defined" type of message.

Am I doing something wrong, or is the only way to access the code via a menu
command or button?