Would like a macro to take me to Document Properties when file is saved

[Alex20850]

I am looking for a macro that would take me to File, Info, Properties, Advanced Properties when I run the macro.

 

[rlv01]

One way:

'
' Tested under Excel 2010. May require adjustment for other versions
'
Sub OpenAdvancedProperties()
    Application.SendKeys ("%fiqs{down}~")
End Sub

 

[Alex20850]

Thanks!!

 

[Alex20850]

One way:

'
' Tested under Excel 2010. May require adjustment for other versions
'
Sub OpenAdvancedProperties()
    Application.SendKeys ("%fiqs{down}~")
End Sub

I am sure this worked with Excel 2016 before, but now it isn't working.
It just takes me back to the spreadsheet.
When I press the keys in the macro, it takes me to Advanced Properties as the macro would.
What needs to be changed?

 

[shg]

How about ...

Application.Dialogs(xlDialogProperties).Show

 

[Alex20850]

How about ...

Application.Dialogs(xlDialogProperties).Show

Wonderful!! Very simple and easy to use.