cancel
Showing results for 
Search instead for 
Did you mean: 

Expand options Message Box / Expand Mode

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

Actually I would only like the Send Data option to be available for the users when there is unsaved data on the worksheet. Since this is not always the case when using dimension expansion. Users use the normal way to send data.

When I combine eSubmit ja eTool_Expand it will always ask about Clear input or Send data and clear input. Eventhough it has just sent the data in the eSubmit phase. And it will give a message about "There is no data to refresh" if there isn't any changes.

I would like the default answer to be set on Send data and clear input, so that hasty users wouldn't accidentally loose their data. But do you think this is even possible?

Best regards,

Piia

Former Member
0 Kudos

Hi

Those eSubmit functions are helpfull if the data only needs to be sent.

However I would need the button primarely to expand the dimensions on rows. And because I would like to avoid user confusion and be on the safe side, also the unsaved data on the input sheet should/could be sent. Now the default is to clear the user input if there is unsaved (sent) data and that can cause mistakes.

So I would need a safe expansion on dimensions. Maybe send first and then expand, if there is't a way to parametrize the Message box default answer.

Best regards

Piia

Former Member
0 Kudos

Hi Piia,

So, you want the data to be sent first and then you want the expansion to run. Am I right on this understanding?

If yes, then you can keep one of the previously mentioned command for sending the data, then followed by MNU_eTOOLS_EXPAND or MNU_ETOOLS_EXPANDANDREFRESH.

Hope this helps.

Former Member
0 Kudos

Hi,

You can try using MNU_eSUBMIT_REFSCHEDULE_SHEET_REFRESH or MNU_eSUBMIT_REFSCHEDULE_BOOK_NOACTION or MNU_eSUBMIT_REFSCHEDULE_BOOK_REFRESH.

Hope this helps.