My preference is to use command buttons from the control toolbar and enable
or disable the buttons based on whether they are valid to use. It is fairly
easy to impliment but you have given very few details on how you are
implimenting your macros.
--
HTH...

Jim Thomlinson


"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