none
Excel Macros Not Firing RRS feed

  • Question

  • Hi

    I have an excel workbook with a simple macro that fires on WorkSheet_BeforeDoubleClick which works well. The macro displays some data and then ends with cancel=true.

    But when I run the macro from the same workbook on a different machine the event doesn't seem to fire so instead of the macro running I am taken in to editing the cell. Both machines are running Windows 7 and both machines have up to date versions on Excel 2010.

    I have tried rewriting the macro - even recreated the workbook but its always the same. I have checked trust centre options on both machines and they are all the same.

    Any help very gratefully received.

    Max

    Tuesday, January 6, 2015 6:22 PM

Answers

  • Unless you have set the macro options to "Enable all macros (...)", you should also make the folder containing the workbook a trusted location for Excel. Have you done that on the second computer?

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Tuesday, January 6, 2015 7:31 PM