Thread: Deactivate a macro when used and reactivate again
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
  
Posts: 2,819
Default 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

Reply With QuoteReply With Quote