So my problem is that everything works perfectly fine even when i click the buttons, but the second time i want to click them it gives me an error and the whole excel document is almost like in debug mode even after i clicked stop.
I am able to type on other excel sheets however no cursor appears nor the green box around cells when you click them.
This code copies either one or all of the sheets from workbook, opens a new workbook and pastes the sheet there all while being protected. Again it has work in the past but now it only works the first time i click it and none after that and i cant seem to figure out why.
the error on the second try is "method copy of object range failed". But if it worked the fist time why not the second??
thank you
EDIT: also when you exit out of excel after i get this error it says "excel stopped working and is checking for a solution"
Bookmarks