VBA to auto update when opening a workbook

Hi,

When I run the below code on certain workbooks it stops the macro and asks if I would like to update the workbook, how can I make it so it automatically selects yes or no within this formula.

Once again thanks in advance for the help.

Please Login or Register  to view this content.

at the end add

Please Login or Register  to view this content.

At the end just above end sub?

yes so before it closes it calculates and states the norm to automatic

you could use application.calculate too

ok thank you, I will give it a try.