![]() ![]() ![]() & "automáticamente en el lugar correcto", vbCritical & "o simplemente use la x de cerrar, y se guardará" & Chr(10) _ & "Guarde el original, usando el icono guardar," & Chr(10) _ MsgBox "NO SE PUEDE GUARDAR COMO." & Chr(10) _ Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Sheets("HojaEscondida").Range("A4") = "admin" Private Sub Workbook_BeforeClose(Cancel As Boolean) The entire ActiveWorbook code Private Sub Workbook_Open() Is there any small VBA function that does this procedure?Įrror 91 occurred at variable object runtime with block not set If > 0 Then I want at the time it is detected, to close the document until deleting that configuration of Excel. We don't want to get rid of the error by dropping the security level and not prompted for Protected View (for legitimate cases when a users has downloaded from the Internet).At the time of opening a document, it indicates to view it I must enable editing of the protected view. Thoughts on what to try? I'm at my wits end. If added as a mapped drive (manually via File Explorer or using "Cloud Drive Mapper") and I have that drive letter in Trusted Locations, I still get it. The SharePoint Online URL ( ) is in Trusted Locations in Office as well. I've got the customer SharePoint Online site successfully configured and reporting as a "Local Intranet" site even, and still no dice. Unless you need to edit it, it's safe to stay in Protected View". The Protected View message is "Be careful - files from the internet can contain viruses. Word and PowerPoint) opened from the same SPO site do not open in Protected View. Any Excel documents opened from SPO open in Protected View. Customer utilises SharePoint Online for files. I have a customer with a Modern Desktop based on Azure AD join, Intune and M365 Apps for Enterprise (Monthly Channel). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |