Holiday Worksheet for Secret Santa

[bfraser]

For the holidays I'd like to create a worksheet that has a command buttons that when clicked, randomly generates a name from a list (A1:A17) and removes that name from the list to avoid duplicates.

 

[xld]

Try this http://www.mediafire.com/file/4chl1cyqn7x3esg/Chandoo%20-%20Secret%20Santa.xlsm