rolo Member May 19, 2017 #1 Is there any workbook open event so when the user opens the file, it does not appear the "Open as read only" message? Notice that the file is not opened by vba, the file is opened manually by the user Thanks!
Is there any workbook open event so when the user opens the file, it does not appear the "Open as read only" message? Notice that the file is not opened by vba, the file is opened manually by the user Thanks!
PCosta87 Well-Known Member May 19, 2017 #2 Hi, Untested but try the following: Code: Private Sub Workbook_Open() Application.DisplayAlerts = False End Sub If it works don't forget to re-enable them at some point
Hi, Untested but try the following: Code: Private Sub Workbook_Open() Application.DisplayAlerts = False End Sub If it works don't forget to re-enable them at some point
rolo Member Jul 10, 2017 #3 It doesn´t work Seems that the only way to avoid read only message is to open the workbook from another workbook using this Code: WorkBooks.Open FileName:="C:\Book1.xls", IgnoreReadOnlyRecommended:=True
It doesn´t work Seems that the only way to avoid read only message is to open the workbook from another workbook using this Code: WorkBooks.Open FileName:="C:\Book1.xls", IgnoreReadOnlyRecommended:=True
