Search : in
By :

Run macro automatically

Last answer on May 12, 2009 8:32:03 am BST mkg, on Apr 22, 2009 6:15:02 am BST 
 Report this message to moderators

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

Configuration: Windows XP
Excel 2007

Best answers for « Run macro automatically » in :
[Excel] – Running Macro Automatically Show [Excel] – Running Macro Automatically Issue Solution Issue I have a macro in excel which needs to be run twice a day and I don’t even want to open the excel sheet. How can I make this process automatic? If I can convert the macro...
Run macro using one of a number of cells (Solved) Show
Help with Excel VB-Run macro by condition Show
How to log in automatically with Windows XP ShowHow to log in automatically with Windows XP Using the Run feature If you have recently updated your Windows with the Automatic Updates, you will notice that you will not be able to log automatically into your account. This is due...
Automatically Launch a program at PC startup ShowAutomatically Launch a program at PC startup The problem Solutions Not touching the registry By modifying the registry Disable its launch The problem Some programs such as Mozilla Firefox, Internet Explorer or the e-mail programs...
Unable to run executable files (. Exe) ShowUnable to run executable files (. Exe) First Solution Second solution My programs are launching no more It may happen that only executable files aren’t eager open properly: either you have the dialog box "Open With", it opens with...
Download Super Macro ShowSuper macro is a free software which allows to create macro under Windows in order to activate diverse automatic actions. Apart being free, this software is easy to use and requires no knowledge in programming. You just simply click buttons, then...
Download Caledos Automatic Wallpaper Changer ShowCaledos Automatic Wallpaper Changer, as its name indicates, is a screen background administrator. The main features of Caledos : - it supports the image formats BMP, GIF, JPG, TIF, - easy selection of files or folders, - the possibility of...
Download Automatic Backup ShowWhen you lose your data, it is not necessary to persuade your that to possess an effective saving program is the best solution. Automatic Backup is a program which will not only protect your data, but it will also keep the former versions of your...
Introduction to Office Automation ShowWhat is office automation? The term office automation refers to all tools and methods that are applied to office activities which make it possible to process written, visual, and sound data in a computer-aided manner. Office automation is intended...
Ask your question Reply

1

 mubashir aziz, on Apr 22, 2009 6:42:15 am BST
  • +1

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

   
Reply to mubashir aziz
Ask your question Reply
They need your help