Excel - How do I display the "excel options" dialog using vba?

225 Views Asked by At

I want to use vba to display the Save tab from the 'Excel Options' dialog box for our users. File > Excel Options > Save

I'm familiar with the ExecuteMso method. For example, Application.CommandBars.ExecuteMso ("MacroSecurity") opens the Macro Security dialog.

I have the complete "Office 2016 Fluent Control list" but after much time looking at excelcontrols file, I can't find the control name to use.

0

There are 0 best solutions below