start a macro

J

johnT

i would like to start a macro only if a particular range
of cells have been recalculated
 
D

Don Guillett

right click sheet tab>view code>in the left window select worksheet> in the
right select workshet CHANGE.>in the macro

if target.address="$A$1" then call mymacro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Word VBA Copy Heading and Content 4
VBA word change keys 0
Every New Tasks Wants to Start in the Future 1
Continues to move to the right 0
Start a mail merge upon opening the document 1
Drop down list control value in vba 2
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top