We have the simplest button on Excel input sheet which executes the below code.
Private Sub CommandButton2_Click() Application.Run "MNU_ETOOLS_EXPANDANDREFRESH" End Sub
First dialog box is Expand options in case there is unsaved data on the input sheet.
Select the expand mode
- Send data and clear input
- Clear input
Ok / Cancel
The default selection for this dialog box seems to be Clear input. We would like it to be Send data and clear input.
Could you advice me how to change this?