How to press enter automatically when opening workbook

[kummakki]

When I open my workbook, a pop-up window appears because my workbook contains links to other data sources. The "update" button is already selected and I would like to answer it automatically by pressing the enter key.

I already have my Workbook_Open() macro, what is the code for pressing the enter key?

[dogberry]

Sendkeys {ENTER}
Hi

Try the above

Chris

[kummakki]

That doesn't work... Gives me only "invalid char" error...

[JosephP]

the workbook open event will be too late for that. on the data tab choose edit links, then click the startup prompt button and choose the last option.

[kummakki]

Ok, that works. Does it anyway update the workbook also?

[JosephP]

yes-it updates without prompting