Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
stop a macro from being used
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
stop a macro from being used
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
stop a macro from being used
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
stop a macro from being used
Sorry for posting 3 times I do not know what was happening but when I sent
the first long query I got a message error on page try later and this happened twice and then when I logged in later the 3 were there. I am going to try this code now and will let you know my results thanks for reply "JLatham" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Stop | Excel Worksheet Functions | |||
How to make this macro stop? | Excel Worksheet Functions | |||
Stop macro with userform | Excel Discussion (Misc queries) | |||
How do I stop a Macro from running? | Excel Worksheet Functions | |||
Macro to stop at a certain tab and does not go to the next one. | Excel Worksheet Functions |