ProtectedViewWindow.SourcePath property (Excel)
Returns the path of the source file that is open in the specified Protected View window. Read-only.
expression A variable that represents a ProtectedViewWindow object.
The path does not include a trailing character (for example, "C:\MSOffice"). Use the PathSeparator property to add the character that separates folders and drive letters. Use the SourceName property to return the source file name without the path.
MsgBox ActiveProtectedViewWindow.SourcePath & Application.PathSeparator _ & ActiveProtectedViewWindow.SourceName
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.