on 09-22-2010 2:49 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.