AFTER REFRESH problems with a macro in Excel

[miguelruiz]

Hi,

I have a macro in Excel and it runs "MNU_ETOOLS_REFRESH".

This brings up a window with two buttons, "Yes " and "No". If I click on "Yes" Refresh is run, if I click "No", Refresh doesn't run. The problem is I don't know which of the buttons the user clicked and I can't act accordingly.

Any ideas?

Regards,

Miguel.

[Former Member]

Hi,

I dont understand what kind of decision depends on the selection of the user. However, you can try to use MNU_eTOOLS_EXPAND. This will expand the template and refresh. There are no prompts involved and will refresh the template in any case.

Hope this helps.

[miguelruiz]

Hi,

I need to refresh the value of a cell and I act in one way or another depending on the new value of the cell. My problem is that the function of BPC"AFTER_REFRESH" runs even if you click on "No", so that the cell is not refreshed and the results are incorrect.

Regards,

Miguel.