See my reply in you other (1 of 3) inquires on this topic - the details you
provided there do give a better idea of what you want:
http://www.microsoft.com/office/comm...a-b1bd39fcd659


"Ber" wrote:

i need to be able to stop people using a macro twice on the same spreadsheet
untill another macro is used and then allow them to use the first one
again.Please help