Limit the number of times a macro can be run

[Losman500]

Is there a way of limiting the number a macro can run? Maybe writing to a separate text file until a certain number is reached? I have some macros that I would like user to run a limited amount of times.

 

[SkipVought]

You could reset/incriment a counter in a hidden sheet from your macro.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Losman500]

Umm I didn't think of that. I will try it; I may need a little sample code, but let me try to figure it out first.

Thanks Skip!

 

[SkipVought]

Sub IncrimentCount()
  With Sheets("YourHiddenSheet").Cells(1,1)
    .value = .Value + 1
  End with
End sub

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Losman500]

Nice this worked perfectly.

Thanks

 

[DaveInIowa]

Do you want to kill the macro permanently when this number has been reached or do you want to limit the number of times to within a specified time period?