crap maybe i spoke to soon, i still had the old vba code in the document i was pasting into, i tried copying the code to the new document, but i think the table references are off, i dont know where to find the table names in the document to rename them to the referenced names.

also theres a reference to the old button I created. i dont know where to find it to delete it from the 'Object' dropdown menu in vba