Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
protecting formulas without protecting sheet so grouping still wor | Excel Discussion (Misc queries) | |||
Protecting a macro | Excel Discussion (Misc queries) | |||
Calculate working days but change working week | Excel Discussion (Misc queries) | |||
protecting... | Excel Discussion (Misc queries) | |||
up down arrows not working after protecting sheet | Excel Discussion (Misc queries) |