ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Dragging cells in protected worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/226973-dragging-cells-protected-worksheet.html)

rita

Dragging cells in protected worksheet
 
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.

rita

Dragging cells in protected worksheet
 
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.

"Rita" wrote:

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.



All times are GMT +1. The time now is 01:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com