Hello,
I have a multiple page workbook. I have a macro that will copy information from a source sheet within the workbook into another sheet within the workbook, based on certain criteria. When the destination sheet is password protected the macro will encounter an error when trying to paste into the destination sheet, regardless of whether the destination cells are locked or not.
Is there a way to password protect the destiantio sheet while still allowing the macro to paste into it?
Thanks,
~Adam D.
Bookmarks