Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I started this in another thread, but now it seems unrelated to that
thread. I've got what seems tb a valid .XLA file (has the little red square in the upper right hand corner of it's icon, was created by doing a "Save As" and specifying .XLA). When I open a workbook - let's call it "ABC.XLS" and then open the .XLA; the code in the .XLA is visible via Project Manager. When I open up a .XLA code module and then an Immediate window, I can execute code in the .XLA. But when I open up one of the .XLS's modules and then and Immediate window Excel pops a "Compile error: Sub or Function not defined" dialog. I think the .XLA is valid bc with Tools | AddIns | Browse I can add it to the list of ABC's Add-Ins. But even with it added to the AddIn list (as opposed to just being opened at the same time) that code is not available in an Immediate window opened from one of ABC's modules. Seems to me like I had something like this working some weeks back with no problems. Clearly I'm doing something dumb. But what? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I want to cylce through all the open .xla's as well as the .xls' | Excel Programming | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
Saving variables in XLA's | Excel Programming |