Locked Cells

[tamrob23]

Hello All,

I have a question, I have a spreadsheet that I've locked. But there is a particular area that is not locked because the users need to use the dropdown list to make selections. They (the users) are copying and pasting the list into other worksheets which could potentially mess up the spreadsheet is there anyway that I can restrict the use of copy and paste???

Stephens, Tamara.xls
	A	B	C	D
17	General
18	05-02-911AuditTrackingSystem			3.50
19	06-02-903GeneralAdministration
20	StaffMeetings
Oct

 

[Datsmart]

If you are worried about users copy and pasting to other worksheets, protect those worksheets too. You can also protect the workbook so additional sheets can not be added.

 

[tamrob23]

I did protect the workbook but the users have to make comments. I went to Tools>Protection>Protect Sheet, the only thing I have checked is the "Edit Objects" because the users have to make comments. But the downfall on using that option is that they can copy and paste =0(