Thanks for the fast responses guys.... LJMetzger, I am getting a very interesting result with your copy of the work sheet with VBA in it... when I pasted your code into my master Workbook, then added the form control buttons, click them. it keeps opening your copy of the example work sheet you posted here. It does it even if i exit out of your example work sheet.... I don't even know how that could possibly happen. Lol I inserted a Module in my workbook, copy / pasted your code into it. clicked the "Clear" button and row 5 data remains in the worksheet but your example copy pops up with all of Row 5 data removed... Not a usable function but cool to see. Also tried clicking the "Restore Original Data" button... Not a good idea as it locked up Excel for at least 15 minutes until I hit ctrl Alt Delete to End Task... The concept is on point, just does not work in my workbook. Seems awesome in the example though, nice work!!
Bookmarks