Hi,
I have a workbook ("Testing.xls") with a worksheet ("TestSheet" - Sheet1)
This worksheet contains a command button ("Button 1")
This command button runs a macro ("Validate") which is contained in that worksheet
Essentially, I want to copy the whole sheet to a new workbook, and be able to run the "Validate" macro in that new file.
I can successfully copy the sheet, and the "Validate" macro it contains to a new workbook.
However, I can't seem to get the command button in the new workbook to point to the new workbook. It always seems to point back to "Testing.xls"
I have the following code:
This produces a runtime error 438 (Object doesn't support this property or method) on the following line:
Thanks in advance for any help you can provide!
Bookmarks