S
Suzette
Hi All,
I have a customer who has a workbook with protected sheets in it. They have
cells that are unlocked that they enter information in. The user may want
to enter the same information in the same cell in multiple sheets. If the
information is numeric it will allow it. If it is text, the data will
disappear when the user presses enter. Has anyone run across this and found
a solution?
Heck, I didn't even know you could do that until the customer showed me.
Learn something new every day.
I have a customer who has a workbook with protected sheets in it. They have
cells that are unlocked that they enter information in. The user may want
to enter the same information in the same cell in multiple sheets. If the
information is numeric it will allow it. If it is text, the data will
disappear when the user presses enter. Has anyone run across this and found
a solution?
Heck, I didn't even know you could do that until the customer showed me.
Learn something new every day.