Dragging cells in protected worksheet

  • Thread starter Thread starter Rita
  • Start date Start date
R

Rita

How do I NOT allow cells to be copied (dragged with plus sign) when my
spreadsheet is protected. I don't see an option for this.

Thank you.
 
I think I found a work around. I formatted the cell as a list, which can be
typed over. This eliminates the ability to drag the cell. If anyone else
has a suggestion, I would still be interested. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't Drag a cell on a password protected sheet (Excel 2003) 4
Locked cells are still able to be selected with proper protection 1
Drag cell contents 2
Enabling Autofilter and Sorting in a Protected Sheet 2
Excel 2007: mouse cant find cell handle to drag/move 1
minimized excel worksheet cannot drag or maximize 3
Protected worksheet 1
Dragging a cell 6

Back
Top