Call a Macro if ANYTHING on a worksheet changes

[Darth269]

Hi guys,

There are TONS of resources available from our friend "Google"... But I can't seem to get my macro to run.

• I've got a macro in a module Sub T_SETUP().
• When anything in a worksheet calls "DESIGN" changes, (users will be picking from dropdown boxes), the above macro should be called and run.

I've tested the T_SETUP code by stepping through, and it runs fine, but whe I add the below code (and several variations of it), I can't get anything (not even an error) to appear...

In Sheet7 (DESIGN), I've added variations of :

Please Login or Register  to view this content.

I hope someone can point me in the right direction :-)

[JBeaucaire]

The use of a drop down list to make a selection does activate a Worksheet_Change event.

At this point the only way for us to help is to see a sample version of your workbook so we can test your macros directly.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Darth269]

Darn, I was hoping that I wouldn't be asked that, as I cannot upload this Workbook. Is there any sample codes, other posts or tutorial sites that may provide me with guidiance?

[JBeaucaire]

That's why I said "Sample version". You can certainly upload the workbook after all the sensitive data has been replaced by garbage. Just make sure the macro works on the garbage data, too.

[Darth269]

Thank you for your time, but the workbook has Tons of data all linking between sheets. I'll find another way around it.

Cheers though,

Tim

[JBeaucaire]

If you still want help and don't want to upload to a public site, you can contact me through my site below and perhaps I can look at it through a direct email. Cheers.

[Darth269]

OK, anyone who's interested... I got home this morning (I work nights in the UK), and opened it up to take another crack, and low and behold... it ran....

I had to change :-

Please Login or Register  to view this content.

To this....

I had to change :-

Please Login or Register  to view this content.

But it runs. Which is the main thing. The only difference between work and here, is the excel version. I'm running 2010 at work, and 2013 here.

[JBeaucaire]

Excellent. Thanks for the result. Offhand I never use anything except "Call" for sub routines, your "Run" syntax looked trustworthy. Good stuff.

[TMS]

I would expect to see Application.Run rather than just Run. And, more often than not, you can run another macro in the same workbook just by using it's name; no Run or Call.

Regards, TMS