How to Lock sort on a data entry sheet.

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I use a worksheet “Order Entry†to enter new sales order information (a row
for each order). Data is entered in columns A-F. This is a source worksheet
that is linked to a destination sheet in several other workbooks used for
pricing and commissions. Data is entered in the Pricing / Commission sheets
in columns G-L. I want to be able to lock down or protect the Order Entry
source sheet so that it can not be sorted or filtered as this will then mix
up the information on the linked sheets.

Basically allow data entry but nothing else on the Order Entry sheet.

Any suggestions?

Thanks in advance.

Bob
 
francis via OfficeKB.com said:
try using the worksheet protection.
Select all cells that allow data entry
Right click and select Format Cells
go to Protection tab
uncheck Lock cells >> OK
Go to Tools >> Protection
select Protect Sheet >> apply your password if you want.
This allow data entry input on cells and the Sort / Filter is grey out

Does this do what you want?

HTH


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-functions/200812/1

That worked - thanks.
Click to expand...
 
Back
Top