M
Michelle
I have a spreadsheet that is protected so that nobody can
change anything (all of the cells in the spreadsheet are
protected), except for me. I did this by adding myself
in the Allow Users to Edit Ranges, under permissions.
This has worked perfectly, except for when I try to drag
any values down to other cells. It then gives me a
message saying that I can't change part of a protected
cell. What should I do to be able to drag
formulas/values down in my protected worksheet?
change anything (all of the cells in the spreadsheet are
protected), except for me. I did this by adding myself
in the Allow Users to Edit Ranges, under permissions.
This has worked perfectly, except for when I try to drag
any values down to other cells. It then gives me a
message saying that I can't change part of a protected
cell. What should I do to be able to drag
formulas/values down in my protected worksheet?