i want my macro to run automatically instead of via shortcut key

[hopefulhart]

hello, can someone re-write/add to my code to make it run automatically when any cell is changed/updated? all the cells in the range update automatically from other workbooks.

Please Login or Register  to view this content.

[HaHoBe]

Hi, hopefulhart,

before we would be able to help you with your request you would need to add code-tags to the procedure as required by Forum Rule #3.

And you should make clear if the update is done via Formulas (Calculate) or Queries (Change).

Ciao,
Holger

[hopefulhart]

sorry about that...newbie.
anyways, all the cells are updated via formulas, i dont manually change any of the cells that my macro covers. i figured out how to get my macro to fire when i manually change cell values but i dont do that, they are all updated automatically and i havent had success getting it to work

thanks

[HaHoBe]

Hi, hopefulhart,

if you will not refer to teh cells or sorting of that particular workhsset you could use the Worksheet_Activate-event to trigger the sorting when you switch to that particular sheet. Right click on the worksheet Tab, choose View Code and insert the following code in there (Sheet should be "Skaters"):

Please Login or Register  to view this content.

I placed your macor in a standard module. Please mind that you would to specify the module name if you have more than one macro of the same name in various standrad modules.

Ciao,
Holger

[hopefulhart]

ok so i put your code where you said to, but nothing when i switch to that workbook. my macro is located in my personal workbook. what did you mean by put it in a standard module?

[HaHoBe]

Hi, hopefulhart,

my macro is located in my personal workbook.

You should have posted that earlier on because at least I assume that the macro was located in the workbook in question.

Please Login or Register  to view this content.

You would need to alter the name of the personal workbook if you still use personl.xls.

Ciao,
Holger