Deactivate a macro when used and reactivate again
 

I need to be able to prevent people using a macro twice in a spreadsheet
untill another macro is run and then allow the first macro to be used again

Deactivate a macro when used and reactivate again
 

One method would be to set/clear and check flags

Ber wrote:

I need to be able to prevent people using a macro twice in a spreadsheet
untill another macro is run and then allow the first macro to be used again