Thanks I edited macro to yours and yeh message pops up so macro is running but not updating fields. These are used for invoices for past 8 tears or so have worked fine every month until last week. Running Office Pro 2016 not changed that and win 10pro which obviously updates. If i turn off restricted editing macro blanks all fields which isnt helpful. it used to work fine with it on. Each month would just edit dates and number of runs in invoice hit macro button to update totals then save as pdf. so no idea whats changed but something has.