Thread: Run-once macro
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Run-once macro

Ah-ha..........increased security......

Thanks, Jeff

Vaya con Dios,
Chuck, CABGx3



"Jeff Standen" wrote:

There are probably a number of ways, but I would get it to create a Name
(hidden) with a particular reference when it runs. Then, at the start of the
SelectionChange event you could look at the name to see the value and run it
or not based on that.

Jeff

"CLR" wrote in message
...
Hi All...........
Is there a way to have a SelectionChange macro set up so it will run the
first time it's called upon, and as a last item, disable itself to never
run
again unless "reset"?

TIA
Vaya con Dios,
Chuck, CABGx3