Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where else to look for procedure call
AHA! Yes -- I see now! I had forgotten about Defined Names not necessarily
being a Range actually on the worksheet! So, when I saw the Defined Name auto_open I was trying to find THAT PLACE on the sheet instead of paying attention to it's refers to action. Many thanks for setting me straight! "Lulu" wrote: I have an Excel95 file name Time.xls. Have second file called macro.xlw which is a single sheet named MACRO and is Excel4.0 Language. Upon open of Time.xls, error says cannot file c:\macro.xlw\macro!auto_open whcih is assigned to run with this file. Have searched Time.xls for call procedure command so I can disable it. Cannot find. There is no hidden sheet. There are no hidden cells. Nothing in XLSTART. No macros attached to this sheet that I can spot. If macro.xlw is workspace, I should still be able to open file time.xls independent of workspace, right? If I copy sheet from Time.xls to another file, still get error. If select occupied cells, copy and paste in new file, error does not happen. So clearly this call command is somewhere, somehow connected to this sheet. I have run out of places I can think to look. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
call procedure problem | Excel Discussion (Misc queries) | |||
Where else to look for procedure call | Excel Programming | |||
Selective call procedure | Excel Programming | |||
call procedure | Excel Programming | |||
procedure won't call | Excel Programming |