Help with some strange issues

I need some help with some strange issues.

I have some very simple code that makes two pictures either visible or hidden depending on the value of a certain cell in the spreadsheet. I want the code to run after I change or click on a ListBox in the worksheet. I have this all worked out and it works just fine!

The problem: The codes runs when ever I change anything on any other spreadsheet that I open! How does that happen?

Example: I open the Spreadsheet Traveler New - I open a new workbook (works the same if I open an exsisting workbook) - I type 123 in any cell on any sheet in the new workbook - and error message comes up that says run time error, and asks me to debug - I click on debug and it brings me to the code I have for the original spreadsheet.

Why would this bee happening?

Hello Ijit,

There are many reasons why this may be happening.You need to post your code before that question can be answered.

Sincerely,
Leith Ross

I attached the actual spreadsheet, but here is the code:

Please Login or Register  to view this content.

Hi Ijit,

Do you have any event code procedures elsewhere? Say perhaps a Worksheet_Change event?

Sincerely,
Leith Ross

Is there a way to search for them? I do not have any event procedures in this workbook, besides the one I posted, that I know of. But I would love to be able to produce a list of all exsisting event procedures. Is there a way of doing that? I looked at all the exsisting modules and the This workbook code and none of them were event based.


Can I attach a copy for you to look at?