K
KSO
If you have a protected sheet in a workbook, A, and you CUT out some of the
unprotected cells from A and paste them in another workbook - then the
"protected" cells in A changes !!!!!!!!!
Sample:
Insert some dates in column A.
Insert formula in column B to extract the dayname from the date in column A.
Unprotect column A and protect the sheet.
Save the workbook
CUT out some cells in column A and insert thenm in new workbook B and save B
Look at the formulas in column B in workbook A - they have changed
!!!!!!!!!!!!!
It's a fatal ERROR I think !
How can this be avoided ?
unprotected cells from A and paste them in another workbook - then the
"protected" cells in A changes !!!!!!!!!
Sample:
Insert some dates in column A.
Insert formula in column B to extract the dayname from the date in column A.
Unprotect column A and protect the sheet.
Save the workbook
CUT out some cells in column A and insert thenm in new workbook B and save B
Look at the formulas in column B in workbook A - they have changed
!!!!!!!!!!!!!
It's a fatal ERROR I think !
How can this be avoided ?