Excel Global Macro for confirmation to run any other macro

[purplefox]

Hi all,

I'm looking for some help to find out if this is even possible.

Is there a way to have a global macro (one in personal book?) which when any other macro is triggered asks for confirmation that the user actually wants the macro to run? if then no selected the macro that had been activated is then exited?

Basically on a 3rd party finance tool there are two buttons, one is a retrieve data (Refresh), and the other is a submit data, they are right next to each other and it can happen that submit is clicked by accident rather than refresh. If you accidentally click submit there is no confirmation that you meant to click that button, it just runs, so it would be really useful for a safety macro to identify that a macro has been triggered and step in first to check that you didn;t make a mistake.

I suspect it isn't actually possible but look forward to hearing any suggestions..

thanks

Andy

 

[Fluff]

I suspect you best bet is to contact Oracle & ask them if there is anything you can do.

 

[Jaafar Tribak]

Do you know of a way to get excel to tell me or log what things are called, i.e. if I press the refresh button, for it to log or display what the button is called, what macro is being called?

Which type of buttons are they ? ActiveX or Form buttons ? and are they imbedded in a worksheet ?

 

[purplefox]

I suspect you best bet is to contact Oracle & ask them if there is anything you can do.

Thanks for your time looking at the query, yes I don't think there is an easy work around.

 

[purplefox]

Which type of buttons are they ? ActiveX or Form buttons ? and are they imbedded in a worksheet ?

Hi Jaafar, they are on the ribbon, not sure which category they fall under.