Run macro automatically

Solved/Closed
mkg - 22 Apr 2009 à 01:15
 Guest - 8 Dec 2016 à 07:02
Hello,
I wrote a macro and I want to run it automatically if one special cell change but have problem, because contents cell change by formula in other cell and user must not change any cell, therefore result of formula change in cell but macro not run?!
Thanks

2 responses

mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 166
22 Apr 2009 à 01:42
Try to run the macro as below

copy your code here and you can select it from VBA windows by selecting desired Sheet then on right side window from drop down menu select Worksheet instead of General and from other drop down select Calculate


Private Sub Worksheet_Calculate(ByVal Target As Range)


End Sub
It would be nice if a real example was shown so people new to this could see how it actually works
Rename your macro to auto_open
Thank you Saint - hours of frustration resolved with a most simple solution!