I'm using the below code to open an embedded word document inside of a worksheet in my workbook. I would like to modify the macro so that when its run the active sheet does not change. (simply activating a defined sheet at the end of the macro doesn't work because the User Guide can be opened from multiple places/worksheets) Possible?
Dim oEmbFile As Object
Application.DisplayAlerts = False
Set oEmbFile = Sheets("UserGuide").OLEObjects("DocUserGuide")
Set oEmbFile = Nothing
Application.DisplayAlerts = True