Report

Run macro automatically [Solved/Closed]

Ask a question mkg - Last answered on Dec 8, 2016 at 07:02 AM by Guest
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
See more 
Helpful
+4
plus moins
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
Was this answer helpful?  
Bw- Nov 7, 2010 at 04:41 AM
It would be nice if a real example was shown so people new to this could see how it actually works
Helpful
+0
plus moins
Rename your macro to auto_open
Guest- Dec 8, 2016 at 07:02 AM
Thank you Saint - hours of frustration resolved with a most simple solution!
Reply

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!