![]() >if the users enable it, the file will try to retrieve the data as long as the file is opened. And the answer is no because everything stops until the user responds - so again, code has not begun running at this point. ![]() I am talking about opening prompts and warnings. >Maybe, even prompts and warnings come before the code, can we write a code to close the prompts or warnings? This article, while written for DDE, gives some insight into the various settings involved:ĭDE links are not automatically updated in Excel 2007 Security settings are the choice of the user and should not be able to be manipulated by code. Security settings are something separate. Refresh links is not a security setting, but so you should be able to control that by changing the property to what you want and saving the workbook. Whether the connection attempts to refresh or not should be a property of that connection in that workbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |