I am match captain for a golf league which entails providing from a membership of 70 odd players a list of foursomes randomly chosen. I have tried several of the solutions in the random list thread and have been able to get some of them to work. I attach an example of what I currently use. There are two features that would be nice to have.
1) it would be nice to have a start/stop button so that the randomization does not run until I want it to and stops after I have the list randomized. I have tried disabling macros and setting security level very high but in both cases I get randomization when I don't want it.
2) It would be nice to arbitrarily select the list length since varying numbers of golfers show up to golf every week. I tried one of the programs that claimed to let me set number of choices and list length but it did not work. What I do now is edit the program I have to various lengths, or have several programs for differing numbers of players
Bookmarks