Macro not working on click. As it once did

[dlow]

Hi

I have some code that is in the worksheet module. It works fine out the box. However once I run some code a few times it seems not to work on click. As it once did. I have to close Excel & then it works again.

Here is the code in the module.

Please Login or Register  to view this content.

Okay, so I just want to say that now that I am aware of this bug I have been paying attention as to when it shows up.
I have ran all the Fa... Macros over & over again no problem.
When I tried to run the NWind code I got no result. The code didnt run. Not only that but the other code showing no problems now wont run on click. All of the code works if I go into the editor and run it from there. So could it be the NWind code that is throwing the monkey wrench into myJoy?

Here is the code I am calling. It is in a standard/general module.

Please Login or Register  to view this content.

While I am asking. I was wondering how I could make this more robust. It only does True, but there are times I would like to select the same area to make it False. Any suggestions?

Thanks for your time.
All the best.

dirty :D

[mehmetcik]

You are disabling remote requests.

Why would you do that?

[dlow]

Hi,

I want to open Excel files in their own instance of Excel.
Do you know a better way?
I am not married to what I have; as long as, when the user clicks a specific cell. They are able to change the behavior of Excel to open files in the same / @ the click of said cell a different window. It will do the job.

Thanks,

d

[dlow]

Hehe.....

All that I needed toDo was drop in a little

Please Login or Register  to view this content.

oh yes I did.
So, here is what it looks like now.

Please Login or Register  to view this content.

Now I have my on/off & everything is working great.

Thanks all for your help & attention on this forum.

Lifes good,

dirty ;p