Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
call procedure problem stan Excel Discussion (Misc queries) 2 August 17th 09 06:11 PM
Where else to look for procedure call Lulu Excel Programming 2 November 24th 04 02:14 AM
Selective call procedure jamesa Excel Programming 2 October 2nd 03 10:04 AM
call procedure bob Excel Programming 1 August 9th 03 12:40 AM
procedure won't call John Gittins Excel Programming 0 August 5th 03 08:17 PM


All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"