I have made a macro that does a "copy paste" action. Because the "copy" is on a formula cell, the macro has to do a "paste special" function to just put the numeric value into the new cell. This works fine until I "lock" the sheet.
It then tells me that the file is "locked" and stops the script.
Is there another way to accomplish this in a locked workbook?
It then tells me that the file is "locked" and stops the script.
Is there another way to accomplish this in a locked workbook?