r_mundhra
10-08-2007, 11:19 PM
Dear All
I am looking for a code which shall limit the no of times a macro can be run.
Say I am using this undermentioned simple code:-
Sub PasteSpecialValue()
Selection.Value = Selection.Value
End Sub
I want that, say, after having this code run for x (10) times, the code just does nothing....i.e it becomes inoperative/ ineffective when I am trying to run for 11th time. Here "x" can be set to any number.
Thanx
I am looking for a code which shall limit the no of times a macro can be run.
Say I am using this undermentioned simple code:-
Sub PasteSpecialValue()
Selection.Value = Selection.Value
End Sub
I want that, say, after having this code run for x (10) times, the code just does nothing....i.e it becomes inoperative/ ineffective when I am trying to run for 11th time. Here "x" can be set to any number.
Thanx