I have created several order forms that my company uses for our salesreps. They all link to an account database for autofill.
Everytime a rep opens the form, the dialog box “To Update all links, click yes, To keep existing info, click no”, appears. How can I write a macro that runs when the form opens, and automatically says no, without user seeing?
I thought I had it with the line “open filename” updatelinks=false. That works but must be ran from another workbook.
I have tried the above line Using Private Sub Workbook_Open(), macro seems to ignore the line and ask the question anyway.
Remember, It needs to open without asking or updating links.
Thanks.