Thursday, October 10, 2013

How to enable the content of a workbook?(Excel-VBA)

Each time we open with VBA an excel file, coming from another person, one of the most annoying things is the fact of having to select the "enable content" option.

However, did you know that you can get rid of that security warning directly in VBA? Just write this following code,defining as true the update of the links (the argument of Open method), so for example:

















With the code above we open the file1.xls and we get rid of the update links security warning! ;) A very useful instruction in my point of view!




No comments: