Skip to Content
0
Former Member
Sep 22, 2010 at 01:49 PM

Expand options Message Box / Expand Mode

21 Views

Hi,

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

Options

- 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?

Thank you