software

I have received an XL spreadsheet from a colleague. When I open it I get the
following message:
Cannot find 'C:\...'!Register.DClick, which has been assigned to run each
time [filename.xls]Sheet1 is opened.
I have tried everything I can think of to find where this is set without
success.

Possibly if you go into thr Visual Basic editor Alt F11, and in the left
hand pane go down to where it says ThisWorkbook, double click on this.
Is there an event in the righ window under workbook open? Here or in a
macro that is called from here, there could well be reference to the
file that you can not find

Regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=542359I checked this out but there is no code or macro here. No problem - I have
copied the data into a new spreadsheet and this opens fine without an error.

quot;Davquot; wrote:

gt;
gt; Possibly if you go into thr Visual Basic editor Alt F11, and in the left
gt; hand pane go down to where it says ThisWorkbook, double click on this.
gt; Is there an event in the righ window under workbook open? Here or in a
gt; macro that is called from here, there could well be reference to the
gt; file that you can not find
gt;
gt; Regards
gt;
gt; Dav
gt;
gt;
gt; --
gt; Dav
gt; ------------------------------------------------------------------------
gt; Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
gt; View this thread: www.excelforum.com/showthread...hreadid=542359
gt;
gt;