Results 1 to 3 of 3

Limiting the no of times a macro can run

Threaded View

  1. #1
    Registered User
    Join Date
    08-26-2007
    Location
    India
    Posts
    2

    Limiting the no of times a macro can run

    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 EVER , 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
    Last edited by VBA Noob; 10-10-2007 at 08:58 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1