locked
Manual Update to Excel whilst VBA code is running and updating RRS feed

  • Question

  • I am writing some MS Word Code that is updating an Excel Spreadsheet.  I will have this code runnning every 5 minutes or so.  What the user wants is to be able to do is update some cells manually.  In the Excel routine, I do not "select" any cells, they are all referenced by an address.offset (relative to $A$1) menaing that if th euser selects any cell, it should not affect the auto updating.

    There is a valid reason why I am using word to access Excel.

    Thanks

    Chas

     

    Any thoughts would be appreciated

     

    Thursday, August 25, 2011 1:39 PM

All replies

  • If the user is in edit mode (actively adding content to a cell) VBA is disabled.
    HTH, Bernie
    Friday, August 26, 2011 6:59 PM